Multiple Worksheets with formulas

[annaleemfx]

I am working on a monthly Cash On Hand spreadsheet. I want to have worksheets for each day that my cash changes. The information needed on each sheet is as follows: Today's date, Cash on hand from the previous sheet, amount of money taken in and paid out and I also want to keep track of my currency (so I will know if I need change in $10's, $5's, etc... ). For example I have a sheet named dec. 11 that pulls amounts from sheet named dec 8. How do I create another sheet that will be named what ever date the cash changed with out having to redo my formulas? ( I am using the = then I click on the previous day's sheet, click the cell and hit return. )

 

[philwojo]

I think you could right click on the sheet name (Tab) at the bottom and then choose "move or copy". Then click the check box to make a copy of the sheet and and move it to the end. IT will copy of the sheet exactly as is, formula's and all. Then rename the tab to the new date and update anything else you need to in the sheet.

 

[annaleemfx]

Thanks for your help.... So there is no way to formulate the sheets to automatically pick up the previous sheet's values? Say sheet 1 is copied and renamed sheet 2. Sheet 2 will pull the date and the cash on hand from sheet 1. Then another sheet is created using the copy command. This one is named sheet 3. Sheet 3 is pulling the values from sheet. Is there no way to automatically have the formula change to pull values from sheet 2? Would a lookup formula help? or even create a table to pull from? but will the table be updated daily when the cash changes??

 

[philwojo]

That would require VBA to do that and I don't have the skills for that, maybe someone else could help, or you could do a search on this board as I think there some similar examples to that already that you could probably tweak to your needs.