Hello all,

Have a 4 sheet work book.

on Sheet 1 there are rows of data, as each row is populated is recieves a specific ID number. Now, what I need to do is on sheet 4 when you enter a ID number, I want specifc fields to populate with specific data from sheet 1.

Thank you for any help, if you require any more information please let me know.