I'm creating a workbook with multiple sheets, that is to be semi-interactive.
I have one sheet (CurrentYear) where I enter all of my information (P & L
information for a restaurant). Across the first row the numbers 1-13,
representing the 13 periods. Down the left hand side are all of the account
numbers. Next to those numbers are the descriptions of the accounts. I then
want all of the values to be entered into corresponding cells for each
period. That is the easy part. It's just entering values.
On another sheet (EndOfPeriod), I want to be able to compare the values. At
the top of the sheet I have the user enter in the year and period number. I
then want all the information from the previous period (CurrentYear) to fill
in automatically. I know I need some type of lookup function, using both the
period minus 1 and the account number, but I'm not sure how to do it. Does
anyone have a suggestion? Does this make sense? I'm also going to have
another sheet (PrevYear) with the previous years information on it. I would
like that info to also fill in on the first sheet (EndOfPeriod). Any and all
help would be appreciated.
Thanks

PS. I would try to give examples, but I've noticed that trying to simulate
a worksheet never looks right.