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
fairooz Posts 11 Registration date Thursday May 27, 2010 Status Member Last seen September 12, 2012 - May 29, 2010 at 09:37 PM
Related:
- Copying data in a dfrnt sheet w/ condition
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Tmobile data check - Guide
- How to transfer data from one sheet to another in excel using formula - Guide
- Mark sheet in excel - Guide
2 responses
fairooz
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
12
May 29, 2010 at 03:37 AM
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)
"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)
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 29, 2010 at 06:57 AM
May 29, 2010 at 06:57 AM
I, for one, do not get it. It seems that your data layout is
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.
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.
fairooz
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
12
May 29, 2010 at 07:49 AM
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').
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').
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 29, 2010 at 08:57 AM
May 29, 2010 at 08:57 AM
i still dont see how it can be done
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
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
fairooz
Posts
11
Registration date
Thursday May 27, 2010
Status
Member
Last seen
September 12, 2012
12
May 29, 2010 at 09:37 PM
May 29, 2010 at 09:37 PM
its alright...
I will try filtering
Thanks for your time
I will try filtering
Thanks for your time
