Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have some sub-totalled data in the following format:
Part # Location Qty Comment Part 1 Bin 1 5 Part 1 Bin 2 6 Part 1 Bin 3 2 Part 1 Total 13 Text of Part 1 comment Part 2 Bin 2 4 Part 2 Bin 3 6 Part 2 Total 10 Text of Part 2 comment This data is my master list of all parts but I also have separate lists for each location (ie. a Bin 1 list, a Bin 2 list, etc.) sorted by part number. Using the sample data from Bin 2, here is an example of what I want to do on all my Bin lists: Part # Qty Comment Part 1 6 Text of Part 1 comment Part 2 4 Text of Part 2 comment The question: how do I get the comment (which is on the sub-total row of the master list) on to the individual lists? I tried a Pivot Table but I had to remove the sub-totals and when that happened I also lost my comments. Garth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto updating list | Excel Worksheet Functions | |||
Comparing two lists of financial data | Excel Discussion (Misc queries) | |||
Create template that ignors data list rules | New Users to Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) |