On sheet 1 I have a work order form. On sheet 2 I have a customer list. I want a button on sheet 2 that will fill in customer info on sheet 1.

So you can select one (highlight customer name) and click a button and it will put the customers name under "customer name" on sheet 1. Then it goes over one column and puts the value of that cell (address) into the "address" feild on sheet 1, and so on.

My biggest problem doing this is getting the macro to remember the row its on during each funtion. I know I'll probably need to use DIM or INDEX, but I havent gotten good enough to figure those out from scratch.