Replicate Information To New Worksheets

[shawnr72]

I have a worksheet with about 15 different material types. This is the worksheet where I want to be able to enter data for all the items. Then I would like to be able to have a separate worksheet for each of the material types by themselves with a chart. How can I create these new worksheets so I only have to enter information on first sheet and it pulls the information back? I was hoping to be able to copy the information somehow, but I wonder if I need to go into the individual worksheet and reference back to the specific cell in the overall worksheet.

Any thoughts?

[Pete_UK]

If you attach a sample workbook then I can show you how it is done using 3 basic formulae. I presume you have a column in your master sheet where you specify the material type, and that this links directly to the name of the sheet where you want the record to be copied to.

Pete