Hi All, I am trying to write a macro that will auotfill some fields on a form sheet (as in a worksheet made to look like a form not an actual form) from a second data source sheet. The data will be a large and unfriendly database dump. Users will want to plug in an ID number on their form, click a cmd button and see the generic Project Details fields auto fill based on a comparison of the ID the user entered and the ID column in the source sheet. I have attached an early test version. I have made some headway with the code but its crap, doesnt work and would almost certainly confuse matters so I haven't posted it. Will do when/if i get it anything like working. Thanks for any help in advance.