Hello everyone.

I have a question about pasting data into a worksheet.

The worksheet columns are A - F. In column B and C, I have data that is manually input. I am copying data from another application that is set up in a table with 4 columns and pasting it to the worksheet. My question is, can I paste the data in column A and have excel automatically move the copied data's second column to excel column D without overwriting column B & C. In essence, column 1, 2, 3 & 4 of the pasted data will be populated in columnsA, D, E & F of the worksheet skipping over B & C. This probably sounds confusing but if anyone can help, I would appreciate it!


Best regards,

Steve