Copy required data based on matching condition

**raghav.k** · 04-25-2011, 01:16 AM

Hi,
I am trying to copy data from one sheet to an other based on a matching sequence number. When I select a particular sequence number in sheet 1 which is column A, I need to check that value in a particular column in sheet 2 which has the data. Then starting from the next line where i find the matching sequence number I have to copy the next 21 rows back into sheet1 starting from column B. Please let me know how i can achieve this.

Thanks

**tigeravatar** · 04-25-2011, 11:02 AM

raghav.k,

Will you be bringing information over in a loop (for all values in column A) or just targeted information once based on a selection from column A? Also, a sample workbook would go a long way to letting us know exactly what you're looking for.

~tigeravatar

**raghav.k** · 04-25-2011, 12:05 PM

hi
Thanks for reaching out.. Please see the attached file.. What i am trying to do here is, i have a submit button on InitiativeImpactData tab, when the user clicks submit the data is stored in InitiativeData tab. Everytime the user clicks submit, the data is appended. Now i am trying to retrieve the data on Sheet4, so when i select the sequence number from dropdown B7, i need to look for the same sequence number in Initiative data tab and copy the rows associated with that seq number for the columns F-L on sheet4. Could you please assist?

thanks

**tigeravatar** · 04-25-2011, 12:46 PM

raghav.k,

Alright, because of the way the data is setup, I used a worksheet change event (in Sheet4) to retrieve the desired information. It looks for the sequence number (selected from the drop-down list in Sheet4) in the InitiativeData worksheet and copy/pastes that sequence number's information to the correct location in Sheet4.

Notes:
-This can only bring in one at a time (so there can only be one item selected to view in Sheet4). This is because of how the data is setup.

Please Login or Register  to view this content.

I have attached a modified version of your spreadsheet so you can see how it works.

Hope that helps,
~tigeravatar

**raghav.k** · 04-25-2011, 01:35 PM

Hello,

Thanks you so much for your help.. I hope you wouldnt mind if i asked for another help.. now on the same excel that i had attached, is there a possibility to get the data in a single row, what i mean is for ex: when i hit submit on the InitiativeImpactData tab, i need the data to be populated in a single row like
Seq No Name LOB Decision SH-RG-MHA-Impact-Type SH-RG-MHA-Impact-Risk etc,

I have attached the sample sheet as well.. Please let me know if this is possible

Thanks in advance

Raghav