F
Facility Manager
I have a large budget spreadsheet that has line items for individual months
(each on their own tab) that I need to feed into an "Overall" worksheet which
in turn feeds into a "YTD" sheet. Each month there are different amounts of
items in any given GL account, so the formulas are always different. How do
I use January's column from the "Overall" tab to fill February's info, even
if they have different quantities? Example: In January I might have 4 items
charged to GL account ABC with the total listed in G9 and in February there
are 12 items, with the total listed in G17 on the Individual month sheets. I
need both of those totals to feed to the "overall" sheet, without having to
copy each line and change the "Jan 07 G9" to "Feb 07 G17". I have a few
hundred line items and can't spend that kind of time doing so.
Thank you,
William
(each on their own tab) that I need to feed into an "Overall" worksheet which
in turn feeds into a "YTD" sheet. Each month there are different amounts of
items in any given GL account, so the formulas are always different. How do
I use January's column from the "Overall" tab to fill February's info, even
if they have different quantities? Example: In January I might have 4 items
charged to GL account ABC with the total listed in G9 and in February there
are 12 items, with the total listed in G17 on the Individual month sheets. I
need both of those totals to feed to the "overall" sheet, without having to
copy each line and change the "Jan 07 G9" to "Feb 07 G17". I have a few
hundred line items and can't spend that kind of time doing so.
Thank you,
William