copying with a Macro

[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.
This is the macro that I recorded. I’m NOT a programer, I can record a
macro and understand VERY little of visual basic. Can anyone help me???
Thank you
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

 

[Guest]

Which cells change, and how do they change. Can you specify how one would
objectively determine which cells are to be affected, or is it purely
subjective?

Provide a little detail and you may get some help. Otherwise, this is too
vague a request.

 

[Guest]

In my workbook there is four sheets, the two that matter are named work in
progress and receipt. My problem is that I need to copy the customer’s name
from in progress and put it on receipt, then copy the address, then city,
then state, and then zip code from the in progress to the receipt, placing
them in the proper order. Each customer’s name is on a row, the first one may
start at C4 for the name, the address is F4, state is G4 and so on. The next
customer’s name that I need may start at C8 for the name , address F8, state
G8. The problem with the macro that I recorded is it is set at C8, I need to
be able to pick which customer’s name and address.
This is the macro that I recorded.
Thank you
Don