matching and consolodating = frustrated

[jdbyrd3]

I have 2 spread sheets with corresponding information.

Both spread sheets contain work order numbers (WO) and Property IDs (PID).

One sheet, "ADMIN", is intended only for the eyes of administrators and contains information that need only be manipulated by them.

The other sheet "Data" contains information that is entered by data entry specialists. All of the information corresponds by WO and PID, but is on two different spread sheets and may not be in corresponding cells.

Is there a way, to consolodate this information onto one worksheet by referencing and matching the WO and PID so that I do not have to retype the information?

I hope my question is clear.

Thank you

 

[Glory]

Yes it's possible, with the right information. Try providing the information in this format:

1) column/row, sheet, header title; 2) column/row, sheet, header title

And be sure to clearly state the desired result (where you want what to go; column/row, sheet).

 

[Glory]

If you want to tackle it yourself, check this thread for a simple example:

http://www.mrexcel.com/forum/showthread.php?t=545072