Combining books?

[timG]

Hi all,

I have a monthly timesheet that has been saved as a bunch of 1-page
books. I would like to combine all the 1-pagers into one book, and add
year-to-date calculations, and use it on an ongoing basis. No idea
where to start, so any help would be appreciated.

Thanks!

-tg

 

[firefytr]

Hi,

A good place to start would be combining all sheets into one book. D
this by knowing which workbook will be your 'Master' book, then ope
each file, right click the sheet and select Move or Copy. Choose you
'Master' book to send to, no need to create a copy - unless it's th
only sheet in that book. You can create a macro for this if you wan
also. Also ensure the sheet names are different and easily read fo
navigation/future use or calculations. As for calculations, they ar
fairly dependent on how you structure your data, you must keep this i
mind when designing a spreadsheet. HT