| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate data from one sheet to multiple sheets based on a column
Hello,
I have a master worksheet which i populate with all the data for all departments. I want data in seperate sheets with the worksheet name as department. Like I want 1 sheet for Harware one for Software and one for Furniture. Hardware 339231 Hardware 339235 Hardware 339239 Sofware 339243 Sofware 324022 Sofware 324030 Furniture 339243 Furniture 324022 Furniture 324030 Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return multiple cells from a data sheet in a seperate workbook | Excel Worksheet Functions | |||
| copying one cell in multiple sheets into a column on one sheet | Excel Worksheet Functions | |||
| pull data from multiple sheets based on input | Excel Worksheet Functions | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| CREATE NEW WORKBOOK AND SHEETS BASED ON COLUMN DATA | Excel Worksheet Functions | |||
Threaded Mode
