Hi thanks for this tip, however it currently works on this setup however the issue I have relates to the rest of the information I would like to populate based on a drop down selection of users on the form (sheets). Eg user 1 is sheet 1. Does this make sense? Basically I'm after the form to have a drop down box that is a list of the sheets (users) then some of the items on the form then auto populate with the information on the selected sheet/ user... Many thanks again.