hi, i have a relatively easy question for someone, but difficult for me. i'm in a workbook and i'm trying to keep a daily report with a front worksheet and a back worksheet per day. they are named by date (i.e. 030604 f - for front, and 030604 b - for back). i'm trying to keep data flowing and i'm wondering how to refer to a specific sheet each day. i would like to get data from a certain range of cells from march 2 front and refer to it in a different place on march 3 front. i would use something like "RefOnPrevSheet('g4)" or whatever, but there is the back of each day's sheet in between. i need to pull up information on each day and put it in a column named "previous" referring to the former day's "total." any suggestions?
additionally, how could i do the same for a range of cells in a different file? i would like to bring the crew's in-times from one daily file and put it on the back of another worksheet in a different file each day. i would do this for approximately 30 days.
thank you for your assistance in advance! i hope someone can help me.