I am doing Excel VBA code to send emails from Outlook. This is working so far. I would like to add a couple of buttons (or links) inside the email body. The rec
Is there a code or function in excel to do the following: If F8=blank, cut and paste text in G8 in G7 next to text separated by semi-colon.
I have a Power query that finds and replaces values listed in a table that I work through from here Bulk Find And Replace In Power Query But I need to apply it
see the basic function structure function test (first as range) whatever I do inside end function calling the function and first is the address of the first c
I am not trained with coding in any way, but have in the past managed to use codes I found online as part of excel or access using macros or buttons and things.
I have a huge spreadsheet of data that looks something like this: Date IDNumber Item 2021-05-10 1 Apple 2021-05-10 1 Orange 2021-05-10 2 Apple 2021-05-10 2 Gra
I have a macro which theoretically works perfectly but I think it is creating unnecessary processing and calculation requirements which then crashes the file. I
I built a VBA Sub that matches an input string with the equivalent string within a large array and returns a specific string which is bounded to the matched str
> STUDENT SCORE VALID DIF 1 83 YES 0 1 77 YES -6 1 2 NO -99 1 66 YES -11 1 100 YES 34 2 68 YES 0 2 98 NO -99 2 61 YES -7 2
I am new to the forum and VBA codes. I have been searching for an answer to this question and am completely lost. I have a workbook that contains around 36 work
I want to link a "TimePicker" housed on an Excel macro enabled spreadsheet (it has three textboxes for hrs, min, AM/PM with associated SpinnerButtons [SBs] oper
I have a VBA User defined function which takes multiple range references for using it in the code. My problem is when I try to use a particular range reference
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to us
so i'm trying to use a macro to look in sheets one code and paste the information of that code , I'm trying to use a simple macro with advanced filters to do th
How do I return an excel file (version: Office365) using FastAPI? The documentation seems pretty straightforward. But, I don't know what media_type to use. H
Is it possible to create a dynamic Excel Pivot Chart title that includes "(Top n)" where n = the value filter row limit selected by the user? I know the chart
I'm trying to return multiple values horizontally into a table from another table (vertical array). I found 2 formulas : = transpose(filter(Result array, x = v
I was using selenium with VBA and there is the current webpage. I was trying to get the bot to select the "exportbutton" ID, but I have already tried Findelemen
I'm a VBA NewBe (this is my first post asking a question on any VBA help site) working on a Property/Expense Management application in excel. the ComboBoxes in
I have multiple xls files in a directory. each file dataframe headers are different but data type is same. 1.xls Location StreetAddress America Pvtld 80