Hello,
I have developed a macro (attached to a button) that copies data from one row (cells D8, E8, F8 & G8) to a sheet called transmittals. Every time the button is clicked it will then copy the data to the next available line on the transmittals sheet. Basically I want to copy the button down the source sheet many times, and I would like it to change the cell references automatically, so I dont have to. Please can you help me?
Here is my code:
Sub Copy()
mycount = Range("A12") + 1
Range("A12") = mycount
Range("D8,E8,F8,G8").Select
Range("G8").Activate
Selection.Copy
Sheets("Transmittals").Select
Range("A4").Offset(mycount, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
Configuration: Windows XP Internet Explorer 6.0
Copying a cell in excel using macro Excel copy to sheet a if copy to sheet b if Excel "copy formula" Excel autofill macro names Excel copy book 1 to book 2 Excel copy cell above Excel copy data based on value Excel copy merged cell Excel copy sheet from one workbook Excel copy to clipboard macro Excel copy variable range Excel copy vertical to horizontal reference -transpose Excel copying data from other files Excel copying formula to end of data macro Excel vb macro to skip empty cells Excel vba macro form Read cell excel in macro Vba excel copy range to memory