I have a MACRO to activate an open workbook, copy the data, and paste it into my main workbook.
To save space i would like to trim the data down (has roughly 20k lines of data) that i want to copy over by a specific date range.
The reference is based off of a user input value in a specific cell that the user can change for a different date range.
This reference is located in workbook "safety challenge report" sheets "imsot" range("r4") (for the from date)
and the same workbook and sheet but range("s4") (for the to date).
The raw data format starts with the date in column A then has more corresponding data for 11 columns in total A:K
IN VBA:
‘THIS SECTION WORKS FINE- IT HUNTS FOR THE SPECIFIC OPEN WORKBOOK I WANT TO COPY THE RAW DATA FROM. (I KNOW I CAN DO AN AUTOFILTER, THEN COPY HERE… BUT I CAN’T FIGURE OUT HOW TO IDENTIFY MY RANGE OF DATES THAT ARE REFERENCED IN MY MAIN WORKBOOK…
Please Login or Register to view this content.
'THANK YOU SO MUCH, I HOPE I MADE THIS THE EASIEST TO UNDERSTAND. I'm trying to avoid sensitive information so I did not attach the actual file. please let me know if you have any questions!
Bookmarks