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
Bookmarks