nburaq
Board Regular
- Joined
- Apr 2, 2021
- Messages
- 220
- Office Version
- 365
- 2019
- Platform
- 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
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