D
DarkNight
What I’m asking is there some sort of vba code that can check the previous
tab and put a formula in the cell G3 of the current sheet, it will need to
make sure that the tab has a year on it as I have a “ledger†tab so wouldn’t
want in “tab†2008 cell G3=’Ledger’!$EB$36
I’m thinking of putting it in “Years†tab
So my next time I make a copy of “Years†and move to end of sheets and
renaming it 2011 it will then put in cell G3 =’2010’!$EB$36 and so on
I can send a copy of the sheet I’m working on if that’s reqired
Regards DarkNight
tab and put a formula in the cell G3 of the current sheet, it will need to
make sure that the tab has a year on it as I have a “ledger†tab so wouldn’t
want in “tab†2008 cell G3=’Ledger’!$EB$36
I’m thinking of putting it in “Years†tab
So my next time I make a copy of “Years†and move to end of sheets and
renaming it 2011 it will then put in cell G3 =’2010’!$EB$36 and so on
I can send a copy of the sheet I’m working on if that’s reqired
Regards DarkNight