-
auto fill button
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules