Need to make a workbook that pulls and organizes data froma master sheet

[cvnhrman]

The master sheet basically looks like this

Name	SCU	Mowing	LIghting	Irrigation
Adams, A	x		x	x
Bass, F	x	x		x
Catz, D	x	x	x
Smith, S		x	x	x

and etc.


I want to be able to make a sheet for each of the categories in the columns. If there is an "x" in that category then it gets pulled to that sheet. On which we will have a cell that corresponds to that customer to make notes about that specific customer. I need this to be able to update as customers are added.

Thanks in advance for all your help.

[azumi]

What the results look a like? And try to upload your example workbook, clikc "Go Advanced" button and then find Paperclip Image Button to attach the file...

regards

[cvnhrman]

For some reason it won't let me upload. It just spends in circles forever. I will email myself a copy and try from home later.

[azumi]

No, I meant you sample file, not your actual file, you can make fake data on it, as long as its describe the problem....


take care...