Save Data from Excel Spreadsheet
 

Hello

Need some Help saving data to another sheet so I can Add all hours and
payroll amount for each week and monthly
The sheet i made is a schedule. The user pick the month and the week.
So I am trying to save each week's hours
to another sheet so I can add them up

Thank you so much in advance for your help.

Save Data from Excel Spreadsheet
 

On Mar 19, 12:42 pm, wrote:
Hello

Need some Help saving data to another sheet so I can Add all hours and
payroll amount for each week and monthly
The sheet i made is a schedule. The user pick the month and the week.
So I am trying to save each week's hours
to another sheet so I can add them up

Thank you so much in advance for your help.

What I *think* you want is to copy the same range of cells to another
sheet that accumulates the data over time.
Basically what you should do is name the range you want to copy, then
use your macro to copy that range to the destination. Figure it out
by finding the first blank row on the accumulation sheet and pasting
your data there. If you're copying more than one row of data and some
are going to be blanks, then after your paste operation, it'd be wise
to delete empty rows before exiting the macro.