need to copy certain cells from 1 workbook to another workbook

[Gauntsghost]

Hi,
I have 2 workbooks where I need to copy information across automatically.
I need to copy certain cells from the Issue Record Template to the next available row in Investigations Spreadsheet.


I need to copy
A5 -> B
B5 -> C
D5 -> D
E5 -> E
F5 -> G
G5 -> H
B11 -> O
F11 -> J

I was thinking that the action that could run the macro would be entering a yes or no into
F11. The files are kept in the same folder on the shared drive.
I use Excel2003

Thanks

[davegugg]

I would suggest running from a button rather than waiting for a text input into a cell. For example, I'd set up a button that, when clicked, would change F11 to "yes", then transfer the data to the other workbook. Couple of questions:
1 Are you opposed to keeping these two sheets in the same workbook? Do they have to be in different workbooks?
2 Are both workbooks going to be open when this is run?

Assuming the answers to 1 and 2 are yes and yes, this code should work:

Please Login or Register  to view this content.

I wasn't able to test, so if there are problems let me know.

[Gauntsghost]

Hi Davegugg,

1. Unfortunately they need to be different workbooks, as the Issue Record Template would eventually saved under a different name to a different folder.
2. Yes, both workbooks would be open at the same time

[Gauntsghost]

Hi Davegugg,

I was finally able to test. It is copying the data, however it has started at the top and is working it's way down, copying over data that is already there. Is there anyway to make it start at the buttom of the data that is already there. If it is copied from the template using the macro, it is not being copied over, just the data that was there originally.
Sorry I showed a blank worksheet it's just the information on it is sensitive.

Regards
Gauntsghost

[Gauntsghost]

Nevermind. I soprted it out.

Thanks very much for writing this for me.