Copying and pasting cell contents
 

I am hoping that someone can suggest a methodology to perform a simple task
of copying data from one file into another.

The copying I need to do is this

Copy From Copy To
File A File B

Sheet 1 Cell A1 Sheet A Cell C1
Sheet 1 Cell A2 Sheet B Cell D1
Sheet 1 Cell A3 Sheet A Cell C2
Sheet 1 Cell A4 Sheet A Cell C4

The list has a lot more entries than the 4 entries shown. The data is always
copied from the same sheet in file A but has to be pasted to either of 2
sheets in File B


Cheers

Gazza

Copying and pasting cell contents
 

Is there any repeating pattern in the paste destinations?

Tim

--
Tim Williams
Palo Alto, CA


"Gazza" wrote in message
...
I am hoping that someone can suggest a methodology to perform a simple
task
of copying data from one file into another.

The copying I need to do is this

Copy From Copy To
File A File B

Sheet 1 Cell A1 Sheet A Cell C1
Sheet 1 Cell A2 Sheet B Cell D1
Sheet 1 Cell A3 Sheet A Cell C2
Sheet 1 Cell A4 Sheet A Cell C4

The list has a lot more entries than the 4 entries shown. The data is
always
copied from the same sheet in file A but has to be pasted to either of 2
sheets in File B


Cheers

Gazza

Copying and pasting cell contents
 

No - It's the principle of the thing i'm looking for really

Cheers


"Tim Williams" <saxifrax at pacbell dot net wrote in message
...
Is there any repeating pattern in the paste destinations?

Tim

--
Tim Williams
Palo Alto, CA


"Gazza" wrote in message
...
I am hoping that someone can suggest a methodology to perform a simple
task
of copying data from one file into another.

The copying I need to do is this

Copy From Copy To
File A File B

Sheet 1 Cell A1 Sheet A Cell C1
Sheet 1 Cell A2 Sheet B Cell D1
Sheet 1 Cell A3 Sheet A Cell C2
Sheet 1 Cell A4 Sheet A Cell C4

The list has a lot more entries than the 4 entries shown. The data is
always
copied from the same sheet in file A but has to be pasted to either of 2
sheets in File B


Cheers

Gazza