I would greatly appreciate your help with a project I doing at work. I
checked the group and can't find any posts on it. Here's the scenario:

1. You have two separate workbooks.

2. You go to Worksheet A in Workbook 1 and select/copy some numerical
data in a table. The selected range covers 6 columns, say cells B5
through G50.

3. Then, you go to Worksheet A in Workbook 2 and paste the data into a
similar table, selecting the upper left cell in the table and then
selecting "paste." Simple, right? Here's the problem:

When you paste the data into the table in Workbook 2, you want to
paste it into every OTHER column in that table. Thus, after you paste
it, you'll see the 6 columns of the original table, with a blank
column to the right of each one. How do I do this? Please reply to
the newsgroup.

Many thanks,
Ron M.

I don't think you can do this in one step...

You can record a macro, copy and paste columns one by one and then just run
the macro whenever you want to paste again...

Other option is to enter formulae like
=Sheet2!A1 in A1 of Sheet1
=Sheet2!C1 in B1 of Sheet1 and so on and copy down...


--
If you find this post helpful pl. choose "Yes"...


" wrote:

I would greatly appreciate your help with a project I doing at work. I
checked the group and can't find any posts on it. Here's the scenario:

1. You have two separate workbooks.

2. You go to Worksheet A in Workbook 1 and select/copy some numerical
data in a table. The selected range covers 6 columns, say cells B5
through G50.

3. Then, you go to Worksheet A in Workbook 2 and paste the data into a
similar table, selecting the upper left cell in the table and then
selecting "paste." Simple, right? Here's the problem:

When you paste the data into the table in Workbook 2, you want to
paste it into every OTHER column in that table. Thus, after you paste
it, you'll see the 6 columns of the original table, with a blank
column to the right of each one. How do I do this? Please reply to
the newsgroup.

Many thanks,
Ron M.