copy and pasting rows from 1 sheet to another

leek78

New Member
Joined
Feb 6, 2025
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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!
 

Attachments

  • sheet1.jpg
    sheet1.jpg
    170.1 KB · Views: 4
  • VBA script.jpg
    VBA script.jpg
    158.1 KB · Views: 4

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Hello & welcome,

You can replace

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

So you copy columns A to P.
 
Upvote 0
Solution
Cheese and rice. That easy. Now to take 2 pills from banging my head on the wall for many hours. Thankyou so much.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,697
Messages
6,192,499
Members
453,727
Latest member
tuong_ng89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top