pasting in excel

[kavanagh]

i am creating a time sheet helper i have lists of numbers such aa
row

251 10 4000251
252 10 4000352
256 10 4000333
this list is endless

i have 16 spots on a time sheet to enter into vertically y7 down to y22
i created a button for each set of numbers
to paste each set of numbers into the time sheet when selected

i need the code for when i select the button for the first set of #s to go to the first spot Y7, then when i select Another button for another set, to go to the next spot down Y8 and so on until finished any help would be appreaciated ps there is usually only 5 or 6 numbers selected in a day

 

[VoG]

Hello and welcome to MrExcel.

Can you post the code for one of your buttons.

 

[kavanagh]

ActiveSheet.Shapes("AutoShape 8").Select
Range("A4:L4").Select
Range("L4").Activate
Application.CutCopyMode = False
Selection.Copy
Range("Y7").Selec

 

[VoG]

Try replacing that with

ActiveSheet.Shapes("AutoShape 8").Select
Range("A4:L4").Copy Destination:=Range("Y" & Rows.Count).End(xlUp).Offset(1)

 

[kavanagh]

Thank you peter it works great thank you very much i've been stuggeling with this for weeks