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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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
81
mumps
mumps
M
  • Solved
Copy the last sheet from file to another with ignore empty whole column
Replies
7
Views
174
mumps
mumps
W
  • Solved
Count every 15th non-empty cell in row
Replies
6
Views
184
Whitestar127
W
S
  • Solved
Copy/Paste cell if checkbox selected
Replies
4
Views
314
kevin9999
K
M
  • Question
Excel script Cope paste with filters
Replies
0
Views
203
michalina
M

Forum statistics

Threads
1,215,080
Messages
6,123,013
Members
449,093
Latest member
ikke

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