I have a "fill in" form on the first worksheet that I want to write a macro
for that will allow the user to go the second worksheet, choose a value from
that second worksheet and have the macro automatically fill in the value on
the first worksheet. The macro that I have written will jump the user into
the second worksheet, but I can not get it to allow the user to choose the
value, copy it and
jump back to first worksheet and paste. I also can write a macro that will
jump to the second worksheet and then jump back to the first worksheet and
paste the cell that is already selected when the workbook opens. I just
can't get the macro to
allow the user to choose the desired value.
--
Lisa