Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell contents get cut off when pasting Annabelle4876 Excel Discussion (Misc queries) 6 August 12th 08 10:34 PM
Copying cell contents from many cells and pasting into one cell MDN Excel Discussion (Misc queries) 7 December 10th 07 08:56 PM
prevent changes to cell references when copying and pasting MiChaos Excel Discussion (Misc queries) 2 July 3rd 07 04:21 PM
copying and pasting Cell reference names ben Excel Programming 1 March 15th 05 09:27 PM
Copying cell contents to add to existing contents in another cell Dean Sawas Excel Programming 3 April 2nd 04 09:00 PM


All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"