Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer contents from a cell in previous sheet if the sheet is a
What Im 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 wouldnt want in tab 2008 cell G3=Ledger!$EB$36 Im 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 Im working on if thats reqired Regards DarkNight |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
transfer contents from a cell in previous sheet if the sheet is a
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. -- HTH, Barb Reinhardt "DarkNight" wrote: What Im 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 wouldnt want in tab 2008 cell G3=Ledger!$EB$36 Im 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 Im working on if thats reqired Regards DarkNight |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer cell data from sheet to sheet? | Excel Discussion (Misc queries) | |||
Copying the repeated data of the previous sheet to the next sheet | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions | |||
Transfer/Copy Sheet, Dynamically linked Sheet | Excel Discussion (Misc queries) | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions |