Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Help
I have made a workbook containing 52 pages, one for each week of the year. I
am attempting to have the data place within the week carried over to the next week and to update the fields. Right now I have to do a copy and paste to accomplish this. Is there an easier way? Thanks for your replies. Kevin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Help
Not what you had in mind, but...
I think a much easier way is to use a single worksheet and add an indicator column for the date/week number. Then you can use data|filter or data|subtotal or data|pivottable to see lots of different "slices" of data. Kevin wrote: I have made a workbook containing 52 pages, one for each week of the year. I am attempting to have the data place within the week carried over to the next week and to update the fields. Right now I have to do a copy and paste to accomplish this. Is there an easier way? Thanks for your replies. Kevin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
Copy cells based on conditions in one workbook to another workbook | Excel Worksheet Functions | |||
Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) |