newbie help please

[metalman]

I have been recently employed by a school board transportation dept in
florida. We are using excel to track fuel usage. the workbooks are set
up into sheets named for the dates of the month. In a particular area
we have a range of cells that give todays tank reading and previous
days tank reading. Every day I have to manually put the previous days
tank readings into the new sheets todays tank readings ( I hope you
understood that). The readings obviously change every day, is there a
way to have excel move these figures automatically to the next days
sheet when I save the current sheet. I'm sure there is probably an
easy solution, but being new to excel I have no clue. Any help would be
greatly appreciated.

 

[Nicky]

Hi,

Is there a reason why you can't just copy the range of today's values
from today's sheet, and paste them on tomorrow's?

Alternatively, this could easily be done with a macro, but for this we
would probably need to see the sheet, to work out the addresses of
ranges data are to be copied from and to. If that's what you want, try
attaching a copy of the sheet.