Copying and pasting cell contents

G

Gazza

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
Some help with a workbook please 1
Repeat Macro 3
Search for the cell content between sheets and copy corresponding 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
open excel file and copy data to another file 4
Macro to increase cell range by 1 5
An alternative to Target.EntireRow 5

Top