Monthly files

D

dimitry scharff

I have a monthly files where every day is a sheet, the beginning of which
references a cell on the sheet before. Is there a way of having this done
without introducing the link manualy on every sheet?

Ex: A6 of Dec 10 = g24 of Dec 9, etc
Thanks beforehand
 
F

FloMM2

dimitry schaff,
One way you could do this, is to set it up once and save it as a template
file.
The next time you open the file, to input data. When you are done, save the
file as that Month.xls.
The template would be MonthlyBudget.xlt (for example). If you did this in
December 2009. The next time you open MonthlyBudget.xlt and input data for
January 2009, select file Save As and call it January2010.xls.
Hope this helps.
 
D

dimitry scharff

Thanks for your swift answer. By mistake I said "File" and should have said
"Spreadsheet", but I think your solution should work anyway, though.Right?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top