transfer contents from a cell in previous sheet if the sheet is a

  • Thread starter Thread starter DarkNight
  • Start date Start date
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
 
You're going to need to provide more information for someone to answer.
Step by step, what do you want to do (with SPECIFICS). Remember, we can't
see your workbook.
 
Back
Top