G
Guest
I need some help! I have a workbook which has four sheets, the two that
matter are named work in progress and receipt. My problem is that I need to
copy the name, address, city, state, and zip code from the in progress sheet
to the receipt sheet, one at a time and place them in the proper order. The
problem with the macro is the range is set at the time of the recording, and
the cells change each time I use it.
For example when I recorded the macro I started on cell C4, copied name it
to the receipt form, back to in progress, copied address to receipt, and so
on. Now I want to copy the name in cell D4 but the macro is set for C4.
I’m NOT a programer, I can record macro and understand a VERY little of
visual basic. Can anyone help me???
Thank you
Don
matter are named work in progress and receipt. My problem is that I need to
copy the name, address, city, state, and zip code from the in progress sheet
to the receipt sheet, one at a time and place them in the proper order. The
problem with the macro is the range is set at the time of the recording, and
the cells change each time I use it.
For example when I recorded the macro I started on cell C4, copied name it
to the receipt form, back to in progress, copied address to receipt, and so
on. Now I want to copy the name in cell D4 but the macro is set for C4.
I’m NOT a programer, I can record macro and understand a VERY little of
visual basic. Can anyone help me???
Thank you
Don