Results 1 to 3 of 3

Unable to lookup value from one sheet and copy rows from another (multiple)

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2009
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unable to lookup value from one sheet and copy rows from another (multiple)

    Hiya,

    Newbie here needing urgent help......

    Have just coompleted VBA into course and am more confused then when i started - boss is expecting a miracle though and I am running out of time..

    I have a workbook that contains 80 worksheet.
    79 of which contain a unique value in cell A1
    and one which has each of those values in a colum A, followed by another 10 colums with data.

    So I need a code to get the value that is in cell A1 on Sheet ABC, look this value up on Sheet called Raw Data, then copy the row that has that value in colum a...then paste that back into SHeet ABC from the current active cell

    and of course i need to do this for all 79 sheets.

    I have tried but am failing miserably and getting more and more stressed by the minute

    Please Help!!!!

    ****I have added a short version of the file, to better explain what I mean:
    -Take the value in Cell A1 on the sheet ABC(there are 80 of these sheets - all different names, but the required value is in cell A1 on all sheets)- Look this value up in colum A on sheet Raw Data (i know there are only 3 there at the moment, the real spreadsheet has about 3000) then copy the row (C:M) and then paste it to the active cell in spreadsheet ABC (it can't be an absolute referance becuase the row it needs to go into will differ on each sheet)

    The reason I was thinking of vb as a solution is so that I do not need to enter a lookup formula for each colum on each sheet
    Attached Files Attached Files
    Last edited by Lassie1982; 02-04-2009 at 09:12 AM. Reason: Changing Title

Thread Information

Users Browsing this Thread

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

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