VBA Lookup Value Copy, Paste Values between two workbooks

[SDave]

HELP!!!

I have a standard template worksheet called "Input" (the workbooks name is "Input Capture") which spans C12:U1100.

In addition I have a seperate worksheet which is based in an all entirely seperate workbook called "People Data" (the workbooks name is "Succession Planning") which again spans C12:U1100.

What I would ideally like is a macro which matches the value in column C and populates the entire row (much in the same way as a HLOOKUP, only pasting values) with the exception of columns M and Q.

Any help would be greatly appreciated.

 

[John Davis]

Ignore my last post, that doesn't seem to work in the way that I would have liked, seeing as data will undoubtedly be sorted from time to time!!

Sorry John but I'm a bit of a VBA novice. Would it just be a case of writing a lookup as I would do normally?

I assume that I would have to start of using the following:

Sub DataTransfer()
On Error Resume Next
Workbooks.Open ("P:\Group Reward\Team\Sam\Succession Planning Templates\Test\TEST - Talent Tool v2.xls")
ThisWorkbook.Activate


Thanks.

Tools->Macro->Record New Macro

Do your normal process and Excel will record it. You can add the VLOOKUP's during the recording.

After you have completed it then Tools->Macro->Stop Recording.


Then if you'd like you can go to Tools->Macro->Chose the macro and edit it too your needs.