Hi,
If i was using a userform, I might be able to tackle this one on my own.
What I need , is a macro to take data entered from "worksheet1" and fill in next row on a separate worksheet based upon salesman selected from cell C20 in "worksheet1" .
For the sample, I have just 3 saleman in a dropdown list and have labeled worksheets accordingly. If i could get help with say just using info from cells C6,c7 and e6 from "worksheet1" and put it where it goes.
c6 last name is row b on data sheet
c7 first name is row c
e6 trade year is row o
I should be able to work out the rest.
Thanks for looking and/or trying. Sample attached (2003)
Bookmarks