Macro - Code Missing

[Shane]

I have the following code to get information copied from one sheet to another
What i would like to happen is the cell i highlight and then press the macro
button the information is copied to to that position, and not to keep
defaulting to the one shown in the macro
Is there a peice of code i need to add to overcome this, any help you can
give will be much appreciated

Sheets("Pilot Valve Material").Select
Range("A2:B53").Select
Selection.Copy
Sheets("Stock Transactions").Select
Range("A1597").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=27
Sheets("Pilot Valve Material").Select
Range("C2:C53").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Stock Transactions").Select
Range("C1597").Select
ActiveSheet.Paste
Sheets("Pilot Valve Material").Select
Range("D2:E53").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Stock Transactions").Select
Range("D1597").Select
ActiveSheet.Paste
End Sub

 

[Jacob Skaria]

Activate sheet 'Stock Transactions' and select the copy location and try the
below macro..

Sub Macro()
Sheets("Pilot Valve Material").Range("A2:E53").Copy _
Sheets("Stock Transactions").Range(ActiveCell.Address)
End Sub

If this post helps click Yes

 

[Shane]

Jacob - thank you for coming back so quickly
I am so sorry but i don't understand (very new to macro's) where i need to
add the sub Macro
Could you advise please

 

[Jacob Skaria]

You can replace your existing macro with the new macro..

If this post helps click Yes

 

[Shane]

Thank you Jacob, when i replace the code and then run the macro it adds all
the data into side by side columns when i need it to follow the process i had
done including some blank columns to b left ( i add additional info into
these that is not always the same)
I read somewhere that you need to be recorded "relatively" not sure what
this ment