Thread: [Solved] Carry-forward: Tab to Tab?
View Single Post
 
Old 01-28-2011, 01:16 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Mark,

All your 'simple solution is doing is retrieving the value from Sheet_3!H11. It's no different than using =Sheet_3!H11. As such, it'll require you to input the specific cell address that you want to reference for the carry forward every month.

With Bjorn's solution, as soon as you move last month's sheet to sit between the "FirstTab" and "LastTab" sheets, the formula he gave you will break down (it becomes a circular reference).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote