From: Kazlou on 13 Jan 2010 05:59 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
|
Pages: 1 Prev: SUMPRODUCT or COUNTIF FOR TEXT VERIFIED LIST Next: summary |