Copying and pasting?

[awz1]

Hi everyone,

I want to copy and paste a list of numbers from a column in excel to another column in excel. however, between each cell I want an empty cell so that there is a gap between each of the numbers. Then I want to do the same to a second list of numbers but paste them only in the cells that are empty. Is it possible to do this in excel? Otherwise I have to do each cell one by one which may take hours

Ammar

[rvasquez]

Hello there try the below code.

To insert the code press Alt+F8 on your keyboard. Clear the contents in the macro name field and then type InsertNumbers. Then select the Create option.

Copy and paste the below code into the blank space provided. Anything that appears in green is a comment I left to help you understand what I did.

You'll need to change the sheet names to fit your workbook. Sheet1 currently is the worksheet where the numbers are located. Sheet2 is an empty worksheet where the numbers are copied to. Just change the name within the quotation marks to your workbook names to make the code work properly.

Please Login or Register  to view this content.

Exit out of the Visual Basic Window. Select the worksheet where the numbers are located that you want to copy and then press Alt+F8 again. This time Select the InsertNumbers macro option and select Run.

Let me know if this works for you!

Thanks!

RVASQUEZ