I am currently using 2 cash sheets to record daily and monthly income, these are part of the same workbook.
The monthly cash sheet is saved and kept for a number of years, the daily cash sheet however gets printed out each day and then cleared for use the following day.
The monthly cash sheets totals are saved on a different row for each day of the month.
Ideally I would like excel to read the totals from the monthly sheet and put them on the daily sheet, obviously this means it would have to read a different row each day.
Is there a way to set this up without changing the formula every day so other members of staff who aren't so comfortable with excel can use it too?
Any advice is much appreciated
/Nichola
Bookmarks