Macro to transfer data from cells on one sheet to multiple sheets?

[redduck87]

Hi There,

I'm trying to setup a Command Button Macro to allow me to transfer cell values that are currently on one sheet into various different sheets, and if possible also another workbook.

The information will all be completed on Sheet2, but then when clicking the button, what I want to achieve is:

Cells B9:C9, B10:C10, F14:F17, C14:C15, B11, C17:C18, all copied in that order to the next empty row on Sheet6

Cells A37 and C37, copied into columns E and G of the next empty row on Sheet5

and lastly copy cells B2:B3 and A27:C27 into the next empty row of a seperate worksheet named Worksheet2
​

I've looked online at various solutions and keep getting a subscript out of range error just when trying to copy from one sheet to another.

Is what i'm trying to do even possible, as it would save so much time if I could do this?

Any assistance or guidance anyone can provide would be greatly appreciated.

Thank You.

 

[SteveO59L]

"to the next empty row on Sheet6"

which column?