S
sam
hi! I have a form setup for an ordering system (thanks to
the helpful info I got here), but now I'm stuck again. I'd
like for my users to be able to click a button to input
(reference?) all the information onto a different sheet
(labeled Log, the form sheet is labeled Form!) and then do
two things:
1) increment by 1 the Order number (ie: 15+1), but the #15
is from the Log sheet (ie: =Log!A2). Where the log sheet
has numbers 15-30 in column A. This can be modified to
reference from the form sheet (=Form!M9) is the cell of
that number, but I'd like it to automaticly put the
correct sequential number in there (but I don;t care how).
2) clear all the fields (drop down menus, too) to 'reset'
the form for the next order.
So then end result would be to have the user:
1) fill out the form
2) click the button
3) fill out the 'next' form
if this is a macro, please help me on the coding, since
I'm not a programmer.. Thanks in advance for help and I'll
be checking in often in case I need to clear any confusion
up about what I need.
-sam
the helpful info I got here), but now I'm stuck again. I'd
like for my users to be able to click a button to input
(reference?) all the information onto a different sheet
(labeled Log, the form sheet is labeled Form!) and then do
two things:
1) increment by 1 the Order number (ie: 15+1), but the #15
is from the Log sheet (ie: =Log!A2). Where the log sheet
has numbers 15-30 in column A. This can be modified to
reference from the form sheet (=Form!M9) is the cell of
that number, but I'd like it to automaticly put the
correct sequential number in there (but I don;t care how).
2) clear all the fields (drop down menus, too) to 'reset'
the form for the next order.
So then end result would be to have the user:
1) fill out the form
2) click the button
3) fill out the 'next' form
if this is a macro, please help me on the coding, since
I'm not a programmer.. Thanks in advance for help and I'll
be checking in often in case I need to clear any confusion
up about what I need.
-sam