Related:
- Copying data in a dfrnt sheet w/ condition
- Copying data from one excel sheet to another - How-To - Excel
- Copying data from one Excel sheet to another. ✓ - Forum - Excel
- Copying data from one sheet to another conditionally ✓ - Forum - Excel
- Auto. copy a row of data onto another sheet using conditions ✓ - Forum - Excel
- Macro for copying data from different sheets ✓ - Forum - Excel
2 replies
fairooz
- Posts
- 11
- Registration date
- Thursday May 27, 2010
- Status
- Member
- Last seen
- September 12, 2012
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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
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
Subscribe To Our Newsletter!
