I have a spreadsheet I am trying to create for my mother, it is a relatively simple spreadsheet Date, Time, Guest Name and Vendor columns on the totals worksheet. I also have Monday - Friday sheets set up which have the same columns as the totals sheet.
Throughout the week entries will be made onto the daily worksheets showing the sales data (date, time, guest, sales rep, etc.). I'm trying to get my totals sheet to take every entry from each daily sheets (mon - fri) and place themselves into the totals page. I am not sure if I would be able to make just one formula that will look at that particular cell across each worksheet or if it would get far more complicated.
I was wanting to post the file I am using but I was unable to make an attachment. If anyone would have any ideas to help, I would appreciate it.
Throughout the week entries will be made onto the daily worksheets showing the sales data (date, time, guest, sales rep, etc.). I'm trying to get my totals sheet to take every entry from each daily sheets (mon - fri) and place themselves into the totals page. I am not sure if I would be able to make just one formula that will look at that particular cell across each worksheet or if it would get far more complicated.
I was wanting to post the file I am using but I was unable to make an attachment. If anyone would have any ideas to help, I would appreciate it.
Last edited: