Dear Sir/ Madam,
Please find enclosed herewith ONE workbooks:
1. Book1: 1_EXTRACT LIST FROM MULTIPLE SHEETS
The contains 4 sheets, three of them contains sample data and the last one holds the table that requires a proper formula.
My Questions are as follows:
1. How to create a list from data scattered in several sheets vide book1 (sl:1)
Seeking your reply.
Regards,
Somnath Chatterjee
[email protected]
copy all data on sheet 4.
Then you can do remove duplicates (excel 2007 => data => remove duplicaties)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks