Copy and paste multiple columns with specific date to another worksheet

Hello All!

I'm fairly new to Excel VBA and Macro recording but have made giant strides in my project.
If someone could help me with my next task, I'd be very close to complete! Whoo hoo

Thank you in advance!

Every month I get meter readings from a job site. The meter records continuously, every 15 minutes, so ideally there are 96 recordings PER DAY. And there are 6 additional data points. 7 columns total, A:G.

I have a macro set up to automatically generate a worksheet for every day of the month.

What I would like to be able to do is have a macro that searches the main worksheet (with ALL of the data points) and copies all 7 columns that have a 10/1/2019 and pastes it in the worksheet titled 10/1/2019. And on and on...

DATE is in column A.

Is this possible??

Hi !

Yes !

Originally Posted by manebobbymo

What I would like to be able to do is have a macro that searches the main worksheet (with ALL of the data points) and copies all 7 columns that have a 10/1/2019 and pastes it in the worksheet titled 10/1/2019. And on and on...

Questions...

1) What is the name of your "main worksheet"?

2) What row does your meter readings start on? In other words, are there header rows to skip over?

3) What is the actual name of the worksheet titled 10/1/2019 (that can't be it because sheet names cannot have slashes in them)?

4) You said "so ideally there are 96 recordings PER DAY"... does that mean some days could have less (or more) than 96 recordings?

1. Name of main worksheet is just the month for the data. So "September", "October" etc.
2. The data does not initially include headers. I add them in. So data starts at A1:G1.
3. My mistake, worksheets are titled 10-01-2019, 10-02-2019 etc.
4. 96 recordings per day.

I think this macro will do what you want...

Please Login or Register  to view this content.