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

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
 
B

Barb Reinhardt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top