Copying with a macro

[DonT]

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

[Gary''s Student]

Post your code.
--
Gary's Student


"DonT" wrote:

> 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

[DonT]

this is the macro that i recorded
tks
Don

Range("C8").Select
Selection.Copy
Sheets("Recipt form").Select
Range("E15").Select
ActiveSheet.Paste
Range("E16:I16").Select
Sheets("Bid - In progress").Select
Range("F8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recipt form").Select
Range("E16:I16").Select
ActiveSheet.Paste
Range("E17").Select
Sheets("Bid - In progress").Select
Range("G8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recipt form").Select
ActiveSheet.Paste
Range("G17").Select
Sheets("Bid - In progress").Select
Range("H8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recipt form").Select
ActiveSheet.Paste
Range("I17").Select
Sheets("Bid - In progress").Select
Range("I8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recipt form").Select
ActiveSheet.Paste
Range("E18:I18").Select
Sheets("Bid - In progress").Select
Range("E8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recipt form").Select
Range("E18:I18").Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

"Gary''s Student" wrote:

> Post your code.
> --
> Gary's Student
>
>
> "DonT" wrote:
>
> > 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