Hi there, hoping someone can help me out with this...
I will be pasting data in the input tab (see attached file) daily with new and historical entries. I would like to create a macro to copy all the data from row A2:AG## (note the number of entries will be increasing daily) and paste special values into the "DailyReport" worksheet - first blank row (in the current file it would be cell A6, DailyReport, but it will change as more data is entered day over day). The macro will need to remove all duplicate rows as the data contains historical records
Note - column AH on the "DailyReport" contains manually inputted data and will need to align with the respective row after running the macro.
Hope someone can help me out, I read the following link, but wasn't able to customize to my needs.
https://chandoo.org/forum/threads/vb-code-to-copy-data-from-one-sheet-to-another-sheet.42963/
Thanks!
Morz18
I will be pasting data in the input tab (see attached file) daily with new and historical entries. I would like to create a macro to copy all the data from row A2:AG## (note the number of entries will be increasing daily) and paste special values into the "DailyReport" worksheet - first blank row (in the current file it would be cell A6, DailyReport, but it will change as more data is entered day over day). The macro will need to remove all duplicate rows as the data contains historical records
Note - column AH on the "DailyReport" contains manually inputted data and will need to align with the respective row after running the macro.
Hope someone can help me out, I read the following link, but wasn't able to customize to my needs.
https://chandoo.org/forum/threads/vb-code-to-copy-data-from-one-sheet-to-another-sheet.42963/
Thanks!
Morz18