Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,355
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer cell data from sheet to sheet? Jeremy Excel Discussion (Misc queries) 3 December 22nd 07 09:15 AM
Copying the repeated data of the previous sheet to the next sheet Sasikiran Excel Discussion (Misc queries) 1 September 25th 07 03:18 PM
How to Automatically transfer specific Data from Sheet 1 to Sheet Jman Excel Worksheet Functions 12 May 10th 07 05:35 AM
Transfer/Copy Sheet, Dynamically linked Sheet 0-0 Wai Wai ^-^ Excel Discussion (Misc queries) 2 December 23rd 05 11:04 PM
Lookup cell contents in on sheet based on a formula in second sheet Michael Wright via OfficeKB.com Excel Worksheet Functions 1 April 30th 05 04:11 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"