linking worksheets and files

K

Kazlou

I have a worksheet that records sales details from 3 separate tills and
calculates total sales for the day etc. One of the figures from each till
gets carried forward to the next day (and varies each day)
At the moment I have this set up as a week to a file with 7 separate linked
worksheets. I then copy the file and redo the dates, then manually link the
last day of one file to the first day of the next. (Hope that makes sense)
Is there an easier way to do this in Excel where I dont' have to manually do
things.

thanks
karen
 

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

Word- Find and Replace 1
Calculating what staff worked on which product 3
Linking to other worksheets 3
Working with 2 worksheets 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Linking Data from 1 worksheet to another by using dates? 1
Recurring Items in Spreadsheets 2
Total weekly worksheets to quarterly 0

Top