copy and pasting rows from 1 sheet to another

[leek78]

Hi. I'm a Novice, self taught, and google has always been a friend. But now Google can't answer my question.

I have "Sheet1", where I'm trying to copy rows from 1 sheet to another sheet (in this case, JAN to MAR) , and the "VBA script" does this, but it copies the whole row, so over writes my Calc grey boxes on the left.

I only want to copy the row, as far a coloum "P". How can my current VBA script be modified simply to do this, or do i need a completly different script?

Please help!

 

[saboh12617]

Hello & welcome,

You can replace

.Rows(i) by .Range("A" & i & ":P" & i) before the copy instruction.

So you copy columns A to P.

 

[leek78]

Cheese and rice. That easy. Now to take 2 pills from banging my head on the wall for many hours. Thankyou so much.

 

[saboh12617]

No problem ahaha we all went through this, it's always easy when you know.

Glad to help, do not forget to close the topic if the solution is working. Have a good day.