Previous Topic Next Topic

Copying data in a dfrnt sheet w/ condition

Solved/Closed
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 - May 29, 2010 at 03:35 AM
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 - May 29, 2010 at 09:37 PM
Hello,

Greetings everyone...

I want to copy data from one sheet to different sheet but only if a condition is true.

For example,

1st Sheet,

Company Party ID
xxxx x1
x2
yyyy y1
y2

2nd Sheet,

Party ID Valid
x1 N
x2 N
x3 Y
y1 Y
y2 Y
y3 <blank>

So, if the 'Valid' column in the second sheet is 'Y', the 'Party ID' value is copied to the first sheet in 'Party ID' column.

I have a record of 10,000 list. So any assistance would be appreciated.

Thanks in advance

2 replies

Answer 1 / 2
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 12
May 29, 2010 at 03:37 AM
sorry...the values messed up...
"Party ID" is one column with values x1,..y3
"Valid" is another column with either 'Y' or 'N'
in the 2nd sheet

and

x1, x2, y1, y2 are Party ID values in first sheet. 2 Party IDs for one company (Company: xxxx, yyyy)
0
Answer 2 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 29, 2010 at 06:57 AM
I, for one, do not get it. It seems that your data layout is 

Company --|-- Party ID   
xxxx    --|-- x1   
        --|-- x2   
yyyy    --|-- y1   
        --|-- y2

Under such layout how company would align with the data. and if all you want is to copy the valid party id from sheet2, then apply the filter and copy the data.
0
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 12
May 29, 2010 at 07:49 AM
I would have tried to filter, but the Complany name is not sorted...also forgot to mention,
this will also require search function. Like search the party name in 2nd sheet and then check the value. Then put the value in the first sheet if its Valid (i.e if its 'Y').
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
May 29, 2010 at 08:57 AM
i still dont see how it can be done 

Company --|-- Party ID   
xxxx    --|--    
        --|--    
yyyy    --|--   
        --|--



If initially data looked like this, how on earth one can say that what goes where. Your question is either incomplete or is wrong or is not do able
0
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 12
May 29, 2010 at 09:37 PM
its alright...
I will try filtering

Thanks for your time
0