consolidation macro

HI everyone! I am trying to consolidate data from two columns next to each other for a macro. When I recorded the macro, it gave me this code in VBA: Selection.Consolidate Sources:= _ "'C:\Users\random\Desktop\[DensityTest.csv]DensityTest'!R2C2:R823C3", _ Function:=xlSum...

Hi everyone, I'd really appreciate if someone helped me with this problem. Admittedly, I'm very new to all this so please go easy on me. I have a code that consolidates data from a large number of workbooks to a single master worksheet. I'm targeting same cells from different workbooks (for...

Hi, I am really new to VBA and I have created a number of workbooks that Project Managers are required to complete and submit to a folder each month: M:\Business Change - Projects\PMO\JAMES - TEST\Demand Management\Resource Forecasts The only tab they are required to complete is the one titled...

Hello All, We're using excel spreadsheet to maintain our time log and to log other business data. We've a checklist, in that there are two work sheet - 1. Summary & 2. Checklist. We enter our time and volume in worksheet 2. Checklist, and using formulas we got the consolidated data per person...

how would you consolidate dates so you just had the month/year in excel vba? i have a worksheet (raw data) that has date in column A, miles travelled in column B and i want to create a summary report on a seperate worksheet (report) based on month/year (mmm/yyyy) in column A, total miles...

Hi Experts, Could any of you help me out in my worksheet VBA Program. I need to filter and copy a list with its occurences. But it has to be consolidated before that. Please find my worksheet for a better understanding of the problem. Many Thanks and Kind Regards, Antz This is my code...