Thread: [Solved] Carry-forward: Tab to Tab?
View Single Post
 
Old 01-27-2011, 03:54 PM
markg2 markg2 is offline Windows 7 Office 2007
Expert
 
Join Date: Nov 2009
Location: Evergreen, CO
Posts: 344
markg2 is on a distinguished road
Default

Before going further with your suggestion, I was thinking about my question after I left the house and would like to run it by you.

Assume that I have completed Tab1 (January) and wish to bring forward the column total J10 from January to a starting cell in Tab2 (February). With my cursor in Tab2 cell A1, enter '+1*' then click on Tab 1, cursor to cell J10, hit enter. Then the formula in cell A1 of Tab 2 would be 1*(Tab1) J10. I'm assuming that somehow Excel would figure out that I was using cells from two different tabs without me explicitly typing in that fact. Since I haven't explicitly entered any cell coordinates and have cursored to each cell location, Excel would always regard these cells as relative in the event another tab were added in between the Tab1 and Tab2 (which I couldn't imagine doing anyway)?

Mark
Reply With Quote