Workbook Help

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Save Worksheet To Master Workbook 5
Merge Multiple workbook sheets into one workbook 0
Want to keep 'historical' data using formulas 2
Linking workbooks 1
links missing 1
Copying to a new workbook without formulas referencing original wk 1
Current year and current week number 9
Date calculation across workbooks / Workbook naming question. 2

Back
Top