Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables across sheets in a workbook
Is it possible to combine commonon data from 15 different sheets within a
workbook into one pivot table? I am still sorting entries here at the hospital tryimg to find the best way to identify door owners and then display said doors via the service they are under. see below ROOM SERVICE OWNER SECT 10002A EMS TOILET 10002B EMS TOILET 10010A EMS TOILET 10108 EMS STAIRS 10201 EMS HOUSEKEEPING CLOSET OMNI 10202 EMS LINEN CHUTE 10203 EMS TOILET 10409A EMS TOILET 10512 EMS HANDICAP TOILET 10600 EMS TOILET 10600A EMS SHOWER RM 10600B EMS TOILET 10609 EMS HOUSEKEEPING CLOSET OMNI 10610 EMS LINEN CHUTE 10611 EMS UTILITY RM CLEAN 10700A EMS STAIRS 10702 EMS TOILET 10703 EMS TOILET 10707A EMS STAIRS 10712 EMS STAFF TOILET 10107 ENGINEER CLOSET TELEPHONE 10414A ENGINEER CLOSET TELEPHONE OMNI 10612 ENGINEER CLOSET ELECTRIC 10700 ENGINEER CLOSET TELEPHONE 10511 POLICE SERVICES OFFICE 10104 PRIMARY CARE/NURISNG OFFICE 10002 PSYCHIATRY NURSING STATION 10009 PSYCHIATRY DINING RM 10010 PSYCHIATRY BREAK RM 10014 PSYCHIATRY GROUP RM 10101 PSYCHIATRY LOCKER RM 10020 PSYCHIATRY GROUP RM 10100 PSYCHIATRY MUSIC RM -- Thanks, Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
several Offline-OLAP pivot tables on different sheets | New Users to Excel | |||
Macro to Protect Mult Sheets / but allow Pivot Tables... | Excel Worksheet Functions | |||
Pivot tables and work sheets | Excel Worksheet Functions | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Copying sheets with pivot tables | Excel Worksheet Functions |