Paste function

[SteveG]

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

[olasa]

Well, you could copy all 4 rows to a temporary sheet, then have a formula pick out the two first rows. Then copy and Edit>Paste Special>Values

Sheet1:
ColA...............ColB........ColC............ColD...........
=Sheet2!A1......................................=Sheet2!B1
=Sheet2!A2......................................=Sheet2!B2
...


Ola Sandström

[SteveG]

Ola,

That is how I have been doing it but I was hoping there was a way to do it in the permanent data sheet Do you know if there is a way to alter the Paste Special options to make it skip?

Thanks for the info.

Steve