MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column - Copy cells


Posted by Ravi on October 10, 2000 5:35 PM

I have this problem, I would be very gratful if you can suggest something.

I have three columns ID, Name and Suppllier Name in sheet one. I want to copy each supplliers data which is ID and Name in seperate sheet and then rename the sheet to the suppllier name.


There are about 7000 rows of data in total, and about 100 different supplliers.



I would be very gratful if you can suggest something.


Posted by Loren on October 11, 2000 4:40 AM


Use Data-Filter-Autofilter

Posted by Ravi on October 11, 2000 1:37 PM

Thanks Loren, but I have lot of data to filter ad if I use auto filter and do a copy paste it will take a long time. I feel that a automated version of this will be very much appreciated.
More comments are welcome.