Well given everything from above, it sounds like this worksheet change event will work perfectly fine.

As soon as you enter the information in the master sheet it will show up on the individual sheet.

The one thing to keep in mind though, the row needs to be completely filled out before you enter info in the key column.

As far as the attached thread, Jerry has done some fancy formula work which I'm not quite up too on his level.

Its been quite the long day for me and my brain is working on one cell right now so it seems I'm not thinking right at the moment.

I'll hang in there with you and when you get a sample maybe something will spring to light.