Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use cell to determine column in formula
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I determine the last cell in a Column | Excel Discussion (Misc queries) | |||
How to determine the column letter from Cell address | Excel Worksheet Functions | |||
How can I determine the largest physical size cell in a column | Excel Worksheet Functions | |||
Formula to determine row of hi value filtered column | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions |