Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table or Function??
I have six worksheets in a workbook listing the odometer readings for
different types of trucks among other info and i want to be able to create a table that will count the differents types of trucks on each worksheet. Sort of like this: sheet 1 sheet 2 sheet 3 type 1 10 11 9 type 2 5 4 11 type 3 13 10 9 Not real sure about pivot tables with multiple worksheets. Any help? |
#2
|
|||
|
|||
Piece of cake !
Make sure all the sheets used to hold data have the same headings. On a seperate sheet create a pivot table using consolidated ranges (with pulls all the data together). The rest is basic PT stuff. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |