Thread: [Solved] Carry-forward: Tab to Tab?
View Single Post
 
Old 01-27-2011, 01:13 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi,
try this:

=SUM(Tab1:Tab2!A1)

My proposal (might or might not be suitable for your case) is however to create a "FirstTab" and a "LastTab". Both of them should be empty. Place all your month-tab inbetween those two. Change the formula above to:

=SUM(FirstTab:LastTab!A1)

Otherwise you might need to change your formula every month.

Kind regards
Bjorn
Reply With Quote