I'm hoping somebody can give me some advice on an Excel question.
I have an Excel spreadsheet, which has multiple tabs associated with departments, in which data has to be entered each week in. For the sake of argument, let's assume that each tab contains two columns "Credit/Debit Previous" and "Credit/Debit Current".
In week 1, I will enter data into the spreadsheet and this will populate the "Credit/Debit Current" column; "Credit/Debit Previous" will be empty at the beginning. The next week, I manually copy the values of "Credit/Debit Current" from the week 1 to the "Credit/Debit Previous" of the week 2 sheet. This process repeats as the weeks pass.
My question is, is there a way to automate this process of copying the necessary values of one sheet to the new sheet?
For reasons I won't go into, the data for each week has to be included in seperate spreadsheet files.
Thanks in advance