Worksheet Data Transfer/Carryover

[fleetmanager]

I have created a workbook where I need to have data from one worksheet automatically transfer data to another worksheet. I will try and be more specific. The primary worksheet is for tracking entries of parts purchases. One column will contain the unit number of each piece of equipment the part(s) are for. Another column is for the department number the equipment is being used in. The second worksheet shows each piece of equipment listed by the equipment unit number and the third worksheet lists the different department numbers. What I need to do is when a unit number and department number is entered on the primary worksheet in the appropriate columns, that the data for that particular parts purchase then shows up on the other two worksheets in the appropriate row and/or column applying to the specific unit number and department number. I have tried several combinations and have been unable to accomplish this. Any help would be greatly appreciated.

[Carim]

Hi,

Ideally a sample of your worksheet in a zipped format would allow precise response ...

HTH
Carim