Copy Data Based on Date Range

[tranjo]

Hi Everybody,

I have been struggling to figure this out, I am hoping you guys can help me figure this out.
I have attached a spreadsheet. I need to copy data from the influent tab and paste it under the proper date in the summary tab.

I have recorded a macro doing this (see below), only now I need it to automatically go thorugh all rows in the influent tab and automatically find the correct date in the summary tab to paste the row.


Thanks for your help.

Please Login or Register  to view this content.

Book1.xlsx

[Leith Ross]

Hello tranjo,

Welcome to the Forum!

The following macro has been added to the attached workbook. There is a button on the "Influent" sheet to run the macro.

Please Login or Register  to view this content.

[AB33]

Leith,
There is an error(Out of script) on

Please Login or Register  to view this content.

[tranjo]

Thanks guys!

[Leith Ross]

Hello tranjo,

Sorry, my typing is not very good. I left of the "s" on "cols". The line should be...

Please Login or Register  to view this content.