macro

Hi everyone. I have two sheets: (A) master sheet and (B) single store sheet (examples below). I'd greatly appreciate your help with two things: A Formula that dynamically populates rows 2-15 of Col B on "Store 1 Sheet" I tried this but it's off by one row... I think it's treating the "Store...

**Please move if this is in the wrong thread group** I believe I have finally spliced a VBA code together in order to do what I'm trying to accomplish however I can't seem to get the specifics correct. Scenario - I receive 3 emails every night at 8pm that contain 1 excel/csv attachment each. I...

I have been using a spreadsheet that friend made a few years ago that has a macro embedded in it. This past week, Excel has updated to a newer version and now I am receiving a Run-Time error message and am unable to run the macro. Here is the Runtime Error: When I click on "Debug"...

I want to add 30 weekdays to a date instead of 30 days as is in my existing code but can't quite figure it out. I've set up the following: Sub WhyWork() Dim d1 As Date, wf As WorksheetFunction Set wf = Application.WorksheetFunction d2 = wf.WorkDay(Date, 30) End Sub But I need to insert...

I have multiple .xlsm files in a folder. I want to compile data from a specific sheet from all the files and edit the data there which should update the respective source file in the folder. I consolidated data using MS-Excel>Data>Get Data> From file> from folder option. I tried macros but in...

I've been seaching everywhere to find a way to auto filter the table (column E8:E) on all my sheets (more than 100) containing a filter that updates when an employee changes quarter (Dw Day week, DWE Day weekend etc.) It would be nice if it would update automaticly or just when someone opens the...

I have an invoice reconciliation workbook where the first sheet (Data) is a list of the Planned Amounts by Vendor and Project ID. All of the other sheets in the workbook are broken out and named by the Project ID. I'm trying to compare the Planned Amounts by Vendor on the Data sheet to the Total...

Hi all I'm trying to create at macro, that makes data more readable by creating a two-dimensional view, but I'm so stuck. Using data from examples found on differeny webpages, I mange to either have data from column a in rows or data from column B in columns, but I have no idea how to combine...

Looking to leverage either a formula, macro or even a conversion and VLOOKUP. I have a cell A1 that contains a data/time in this format which is in EST. Here are two examples: 8/9/2023 14:04 8/8/2023 6:14 8/9/2023 6:14 8/9/2023 14:04 The date is irrelevant to me and I'm only...

Hello everyone. I need help and my macro ability is weak. I cn hard code easily but my Boss asked me for a special project. I am a paralegal working in Fmaily law. I was taksed to (for now) create a use friendyl chart to decifer which law to use based on a date. My excel sheet #2 holds teh...

Hello Experts, I require your assistance in coding an Excel macro. Currently, I am working on a staff roster Excel sheet with two worksheets: 1. On the first worksheet (w1), staff details are listed. 2. On the second worksheet (w2), mmm supervisor details are provided. In w1, my first...

Hi everyone, Basically, I have a list of names and reasons for people being on a list. Plus the date their names were added to the list. What I'm wanting is for the line with their info to be removed after 7 days when we open the spreadsheet. Referring to the image, lets take row 2-4. Their...

Hi everyone, I've been using the code stated below for some time to create a new column for a "due date" which would be 30 days from the chosen input. The problem is that within those 30 days weekends are not being excluded meaning many of the dates are incorrect. Is there a way to integrate...

My dear community, I am struggling to write a macro that will do the following steps and I would like to ask for your ideas: I would like the macro loop the same steps for addresses marked as 1,2,3,4,..10 all the way to the highest value in 'Addresses' column A. Step 1. Copy data from...

I have a a macro that recursively loops through 37,000 rows of an Excel file to try and find a matching file name in a synced sharepoint file system (Year folders and sub-quarter folders). The conditions are as follows - If a file is found, add the file information to the respective row. If a...

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

hi guys, Because of the way the warehouse guys book the goods in, my system at work splits the orders into multiple lines. I need the macro to identify the split lines and replace them with a single line so that the qty ordered in column K and Receipt Quantity in column L is correct. Is there a...

Hi, I have a macro created by one of my former colleagues. It a bit complex macro with multiple steps which includes application of mutiple formula. He is no longer working for us, and we have decided to move to power automate with Office scripts. I have been decoding each step and converting...

Hi Excelites, Need macro help to concatenate for below table. Rows value in single cell based on value in column A. example as demonstrated below table. ABCDE1Item CodeVendor NamePo NumberQuantityDate2EH1D006-00012KINTECH ENTERPRISE45000954984449593EH1D006-00012KINTECH...

Hi. I am seeing if anyone knows how to create a VBA macro to run a data model I have built using unique rows of variables (input) and recording the output, for 100 different scenarios. I have about 5 unique variables that result in an IRR calculation in my model. Can I automate this so I don’t...