Try this sample from my archives, a non-array formulas solution:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)
Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key column.
In your case, that key column will be where you have the categories:
Hydraulics, Chassis, Electrical, etc
Celebrate success, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Parker Jones" wrote:
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
other sheets.
I have tried pivottables but I am having issues showing the data in it
original form:
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jones