J
Jay
Hi, have posted similar question before but need to clarify it.
I need a user form (got this far) that gives the user three choices.
One is a unique product number (200) coloumn A, the second is a
location (9 altogether) sorted in column B and the third a date (in the
top row).
I need to capture this preset data from the user form and then add a
fourth entry (a number) into the cell chosen from the first three
choices.
Product # Location date1 date2 date3 date4
1 a x x x x
1 b x x x x
1 c x x x x
1 d x x x x
2 a x x x x
2 b [and so on]
x indicates the target cell for the user form.
Yes, it should be a database but there you go.
Thanks in advance for the help
J
I need a user form (got this far) that gives the user three choices.
One is a unique product number (200) coloumn A, the second is a
location (9 altogether) sorted in column B and the third a date (in the
top row).
I need to capture this preset data from the user form and then add a
fourth entry (a number) into the cell chosen from the first three
choices.
Product # Location date1 date2 date3 date4
1 a x x x x
1 b x x x x
1 c x x x x
1 d x x x x
2 a x x x x
2 b [and so on]
x indicates the target cell for the user form.
Yes, it should be a database but there you go.
Thanks in advance for the help
J