Previous Topic Next Topic

Copying data in a dfrnt sheet w/ condition

Solved/Closed
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
 -
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
 -
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
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
 12
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)
Answer 2 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 769
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.
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
 12
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').
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 769
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
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
 12
its alright...
I will try filtering

Thanks for your time
Ask a question