Copy/Paste from next empty cell to last empty cell

J

josephmary

New Member
Joined
Oct 18, 2023
Messages
26
Office Version
  1. 365
Platform
  1. Windows
Hi,
I know this may be simple but I only know a few macros so I had to ask a question :)
As shown on the image, I need U2 to U12 (which is the sections 1.1 to 4.2) be copied and pasted from next empty cell up to the last empty cell
1697641903586.png
 

Attachments

  • Capture.JPG
    Capture.JPG
    31.1 KB · Views: 6
Sort by date Sort by votes
You are welcome.
Glad I was able to help!
 
Upvote 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
You must log in or register to reply here.

Similar threads

excelbytes
  • Solved
VBA Code To Copy Data Into Next Blank Column
Replies
5
Views
151
mumps
mumps
M
  • Solved
Copy the last sheet from file to another with ignore empty whole column
Replies
7
Views
195
mumps
mumps
W
  • Solved
Count every 15th non-empty cell in row
Replies
6
Views
205
Whitestar127
W
S
  • Solved
Copy/Paste cell if checkbox selected
Replies
4
Views
405
kevin9999
K
M
  • Question
Excel script Cope paste with filters
Replies
0
Views
220
michalina
M

Forum statistics

Threads
1,215,694
Messages
6,126,255
Members
449,306
Latest member
RealNinetyThree

Share this page

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