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! |
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! |
All times are GMT +1. The time now is 07:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com