Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Report function?
I have a master worksheet with distributor, product, and price as columns. I
would like to add one worksheet for each distrbutor and populate those worksheets with only the data from that distributor. What kind of function would I use for this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Report function?
If you want to do this as a one-off, then apply autofilter to the
Distributor column, having inserted as many blank worksheets as necessary. Use the filter to select a distributor, highlight the data which is visible and copy it to one of the new worksheets - rename that worksheet. Keep doing this until you have split your list up as you want it. Hope this helps. Pete plunk25 wrote: I have a master worksheet with distributor, product, and price as columns. I would like to add one worksheet for each distrbutor and populate those worksheets with only the data from that distributor. What kind of function would I use for this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |