I have worksheet 1 and 2. In worksheet 1 there are certain data fields that
I draw from and put the information in designated cell addresses in the form
using data validation, the indirect and vlookup function.
For example in cell B2 of worksheet 2, which is the form, data validation
drop down to go to column B7 pull that value and enter the value in cell b3
of the form.
....in cells B5, C30, and E1 of the worksheet 2, the form, I want those
values to be put in cells M7, N7, and O13 of worksheet 1. I used the formula
reference above which does pull the information over; however, when I go to
the next cell in B2 of worksheet 2, for example B8, the information in
worksheet 1 does not stay but changes accordingly, do I need a macro?