Oops. I should have said atpvbaen.xls, not atovbaen.xla. See

http://www.cpearson.com/excel/ATP.htm

for more.

HTH,
Bernie
MS Excel MVP


"mjmcevoy" wrote in message
...
Hello,

I'm trying to automate a tedious task at work but I'm not sure how to go
about it.

We track daily volumes on a spreadsheet.

Column 1 would have each business day for the month. Column 2 through 8
would have various volumes for different items that we enter each day. This
piece can't be automated do to the source of the volumes but what I would
like to automate is adding the next month to the top of the sheet and moving
the previous month down. I cant simply copy and paste the previous month
because the number of business days in each month varies. I would also like
to add the busness days.

The thing that makes this so tedious is that it has to be done on several
sheets.

Any suggestions would be appreciated.

Mike