I'm really sorry if this has been chalked up a hundred times a day, but I have multiple worksheets for different branches of our company. I am trying to have a main page that will have a lookup per a case number eg. 115125 and search the all worksheets for this number, and then display the entire row of info from the search results, and as well be able to edit that info in place. Possible? possible witout using vb?