J
JeffC
Hi, I have a worksheet in which I add a new column each month for the new
activity in the trial balance. that information is in one sheet. In
separate sheets, I have cash flow statements (one for each month, meaning 12
separate sheets). At this point I manually transfer totals from the trial
balance to the cash flow statements. I would like to find a way to do the
following: If I could have all the formulas on the cash flow statement point
to the proper row on the trial balance BUT be dependent upon a variable for
their column selection (columns Jan-Dec), then I could actually have just two
sheets in this workbook... The monthly cash flow sheet would work for
Jan-Dec by just changing that variable, which could possibly be the numbers
1-12, or something along those lines. Thanks in advance, any help would be
GREATLY appreciated
activity in the trial balance. that information is in one sheet. In
separate sheets, I have cash flow statements (one for each month, meaning 12
separate sheets). At this point I manually transfer totals from the trial
balance to the cash flow statements. I would like to find a way to do the
following: If I could have all the formulas on the cash flow statement point
to the proper row on the trial balance BUT be dependent upon a variable for
their column selection (columns Jan-Dec), then I could actually have just two
sheets in this workbook... The monthly cash flow sheet would work for
Jan-Dec by just changing that variable, which could possibly be the numbers
1-12, or something along those lines. Thanks in advance, any help would be
GREATLY appreciated