Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Filtering data and replace on to an new worksheet
I have a lot of info about different suppliers on one datasheet and I would
like to divide this into different sheets. This way I can find the info of each supplier on a separate worksheet and I look at the result of all my suppliers separately. Is this possible? (I'm trying to put this action in a macro, so I can look the results of all my suppliers whenever I want) |
#2
|
|||
|
|||
Hi Jessie
Try this http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jessie" wrote in message ... I have a lot of info about different suppliers on one datasheet and I would like to divide this into different sheets. This way I can find the info of each supplier on a separate worksheet and I look at the result of all my suppliers separately. Is this possible? (I'm trying to put this action in a macro, so I can look the results of all my suppliers whenever I want) |
#3
|
|||
|
|||
You might consider just using the AutoFilter to filter out only the Supplier
you are interested in at the time. Vaya con Dios, Chuck, CABGx3 "Jessie" wrote: I have a lot of info about different suppliers on one datasheet and I would like to divide this into different sheets. This way I can find the info of each supplier on a separate worksheet and I look at the result of all my suppliers separately. Is this possible? (I'm trying to put this action in a macro, so I can look the results of all my suppliers whenever I want) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace data by VALUE or COMMENTS not availabel in Excel 2003 ??? | Excel Discussion (Misc queries) | |||
How do you replace old data with new data without creating a new . | Excel Discussion (Misc queries) | |||
How do you replace old data with new data without creating a new . | Excel Discussion (Misc queries) | |||
copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
Find and replace data in an Excel chart object | Charts and Charting in Excel |