Forum Discussion
coping cells to new worksheet ells
texasowl I know it sounds like a great idea to have one worksheet per month, but it actually makes summary analysis difficult. If you put all your transactions in one sheet, then you can easily use PivotTables to summarize it all.
If you do want to go the formula route, then one way is to put the previous month in an anchor cell in each sheet, and then use INDIRECT to return the value from that sheet. This will return the value from January!B3, where the word "January" is in cell B1:
=INDIRECT($B$1&"!B3")
Now you can copy that to your other sheets, and don't need to adjust anything.
Smitty Smith, Thank you for the assist, however, I think this is just getting a little too much for me? I am not really familiar enough with Excel. I can just keep it as it is.
Thank you again for your help.
