Hi,
I would extract data from the same sheet name from EXTRACTION sheet across files to new file
the new file should add automatically based on date(today) as the name shows SUMMARY RANGES 01-05-2025 , but if I run the macro every time in date today then should replace file(not add many files for the same day ).
so I put sample result in SUMMARY RANGES 01-05-2025 file how should be .
so in column B should show header for each name is existed in column B for each file .
should brings SUMMARY range is existed to bottom for each file , in column A should show ITEMS (1,2,3..)
after brings summary range for each name should create total summary for whole names by sum duplicates items in column B
the files could be 150 files in this directory "C:\Users\MMGG\Desktop\SUMMARY DAYS"
becarful in my real project every EXTRACTION sheet contains sheet before it so this sheet is not first , could be fourth, fivth.... you can say changeable in location .
thanks
Reply With Quote