Previous Topic Next Topic

Copy Data On Condition From One Sheet To Another

Closed
Shkhaslam - 22 Nov 2014 à 04:11
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 22 Nov 2014 à 08:57
Hello,

I have 15-16 sheets.. AND I ENTER data in sheet1 & sheet2 .. i want a code that can copy data from sheet1 / sheet2 to sheet3 or any other sheet based on condition .. I am keeping column b as UniqueCode .. If the UniqueCode is entered in column B in sheet3 or anyother sheet then excel should search the same UniqueCode from sheet1 / sheet2 to match and copy the row and paste in different coloumns that i want in sheet3 or anyother sheet ...After finding the UniqueCode from Sheet1/Sheet2 .. Excel Should Also Search For The Row Which The UniqueCode is And Then Copy The Row And When Pasting To Sheet3 .. Excel Should Search For The Same Heading From Sheet1 And Copy To Sheet3 Under The Same Heading..
So Please If Anyone Could Help Me..

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
22 Nov 2014 à 08:57
I am 100% sure about your requirement. Would that "key" value would exists only once in sheet 1 and 2. ? how much of data sheets would contain

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
How to copy sheets from one work book to other
Sultaaan -
venkat1926 -

1 response
How to copy data from one excel table to other
rkindia -
TrowaD -

1 response