Simple Copy/Paste Question

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
220
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi Gents,
I would like to copy a range of data and paste into another column without overwriting the existing data. Normally, what I do is I copy the range of data and when I am pasting it I choose "paste special" and then click "skip blanks" this way works but in long range of data when I do this it overwrites the existing data always so maybe the empty cells are actually not empty? I don't know is there any way to paste this data with VBA or any other method? Thanks for the help and solution! PS: my scenario look like the screenshot below
copy_paste.png
 
No Col A is col 1 not 0.
Offset( ,-1) is one column to the left of the col it's working on, so for col G that would mean col F
Ohh ok now I got it! Is it possible to solve this with VBA as well ? It will check range A and if a value in a cell is number and sequential then will move value(or paste) from column A to B as highlighted in screnshot? Thanks again for all the help!
paste2.png
 

Attachments

  • paste2.png
    paste2.png
    6.5 KB · Views: 1
Upvote 0

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
That is a totally different question, so needs a new thread.
That said none of those numbers are sequential.
 
Upvote 0
That is a totally different question, so needs a new thread.
That said none of those numbers are sequential.
You are totally right Fluff, thanks again for all the help, my problem is solved and I am really happy :cool:!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

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