Hi,
I have a list of data in multiple worksheet with different worksheet names.What I want is that I want a unique lists from Column A3 & below in a New Sheet.While Extracting unique list it should also copy the data of Q & R column as well.
Hi,
I have a list of data in multiple worksheet with different worksheet names.What I want is that I want a unique lists from Column A3 & below in a New Sheet.While Extracting unique list it should also copy the data of Q & R column as well.
Pls find attached.I have kept only two worksheet.There is infact more than 2 worksheets.
Your example is one that is most difficult to follow. Please read rules. Simple suggestion is to create a Pivot table for the multiple selections, this should automatically create unique list. (your info without a solid example AND solution is too difficult for me to follow, BUT the Pivot table should help you get unique)
Ok how to do for column A assuming that there is no other colums in multiple worksheets.
Last edited by paradise2sr; 07-13-2020 at 11:14 AM.
Try:
Please Login or Register to view this content.
Click the * to say thanks.
Please Login or Register to view this content.
Last edited by sintek; 07-14-2020 at 06:00 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
This issue already solved yesterday by PaulM.
Thanks for your help as usually.
My apologies...
Your thread was not marked as solved and PaulM100 solution did not incorporate the
it should also copy the data of Q & R column as well.
Post 6 solves...I would be thankful to you further if it work out Q& R also.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks