Hello Excel Forum,
I am looking for some help. I have a file that contains data in "Sheet 1". I am looking for a macro that does the following:
1. Copies the data and paste it in "sheet 2"
2. Deletes the data that has been copy-pasted in "sheet 2" from "sheet 1", that way the user can start entering data again
3. Summarize the data in "sheet 2" without deleting any previous data in "sheet 2"
The purpose of this file is to have the user enter data for one date, the macro will consolidate the data and the user can enter the data for the following date.
I am attaching a file to better explain what I need to do.
"Sheet 1" contains the data that will be copy pasted (this data needs to be wiped out or erased once it is copy pasted in the next sheet)
"Sheet 2" is the desired result
Bookmarks