Hello all,

I was hoping for some assistance creating a macro for my situation.

so basically, I have a workbook that contains a worksheet for each day of the month (named "1", "2", "3", etc. to "31"). Each worksheet has a series of rows and columns where the columns are headed with the denominations in question (i.e. $100, $50, $20, etc.) and where each cell within each column contains how much of that particular denomination was removed at a particular time (i.e. -$2000, $-5000, etc.).

Now, B6:R6 are cells which contain that particular denomination's starting cash for that given day/worksheet. Again, we log under each column the cash used (be it positive or negative). The columns then sum them and give day ending cash totals in cells B37:R37.

So, what i'm trying to do it create a general (non-sheet specific) macro that will do the following:

1. highlight B37:R37 on current sheet
2. paste special-value and number formats into cells B6:R6 in the NEXT worksheet in the workbook (this basically transfers day 1's ending cash totals and makes them the starting totals for day 2, day 2 to day 3, and so on)

I attempted to do this by recording macros, however, i can only record 5 in the version of excel my company has (excel 2003) but i need a macro that can do it for 31 sheets. (technically 30 because sheet 1's starting totals must be entered manually)

My plan is assign this macro to a button which will be placed somewhere on worksheets 2 through 31 that will allow the use to click it, and have the ending totals from the previous day(B37:R37) prefill into the current sheet's starting totals cell range (B6:R6).

I do not want to just make the cells from one sheet equal the previous day's values because then i will have 31 sheets that all have figures on them and it will become a little convoluted.


Any help anyone could provide would be MUCH appreciated.

Thanks & enjoy your weekends,

Vin