+ Reply to Thread
Results 1 to 3 of 3

Copy column for cell reference to an existing sheet, with matching sheet name as cell

  1. #1
    Registered User
    Join Date
    11-17-2013
    Location
    Stoke
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy Copy column for cell reference to an existing sheet, with matching sheet name as cell

    Can someonwe please help. I have been trying to sort this out for 2 days

    I have a sheet called Sheet2 that contains many column with data in rows 1 to 29. In row 4 of each column there is a number eg 1234, in the same workbook there are empty sheets with the same references as in row 4, hence many empty sheets.
    I want to copy from sheet2 the information from row one to row 29 in a new column on the empty sheets that have the same number in row 4. There may be several records in sheet two with the same reference in row 4, so these have to be copied to the correct sheet. If the destination sheets already have information in them , then the new data must be copied to the next empty column.

    I have been trying to go sheet2, goes to the first colum, checks to see what reference is in row 4, then copies it to the relevant next empty column in the appropriate sheet. Then return to sheet 2, go to the next column and start over again, until in sheet 2 row 4 is empty, then stop the program

    I have tried, had a bit of success, but always fail in one way or another

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,782

    Re: Copy column for cell reference to an existing sheet, with matching sheet name as cell

    Hi there,

    I just might be able to help you out with this one.

    A question - what is the criterion for determining that all data on Sheet 2 have been processed? Is it encountering an empty column on Sheet 2, or is it encountering a non-empty column which has no value (worksheet name) in Row 4?

    Regards,

    Greg M

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Copy column for cell reference to an existing sheet, with matching sheet name as cell

    Maybe:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-06-2013, 05:20 PM
  2. Copy Row from 1 sheet to another sheet named matching cell value
    By heiny1056 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2012, 04:43 PM
  3. [SOLVED] for each sheet with first 3 char matching variable, copy column C to Target sheet unless..
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 08:17 AM
  4. Find matching cell in other sheet and copy cell from different column
    By level3ninja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2011, 03:29 AM
  5. Replies: 1
    Last Post: 10-30-2009, 10:58 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1