match & offset copying values

[RobAndrews]

Hi,

I have data in A1 of workbook Test.xls which I want to find in column A of workbook Test2.xls, once found I want to return the value of H5 in Test.xls into the corresponding row in column C of Test2.xls

Both worksheets are called Sheet1 in each workbook.

Can someone let me know how I can macro this as I need to extend the same process with further data copying in the future.

Thanks.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I will edit the title this time

[royUK]

Depending on the layouts of the sheets you might be able to do this with VLOOKUP, not VBA.

Post exampl workbooks

[RobAndrews]

Hi,

Sorry for the rule thingy.

I've attached the two files, cell references slightly different to my original posting but the same process applies. I'd like to match the Works Order Number in Test.xls and then transfer data such as Property Ref in C10 into Test2.xls.

I don't pretend to know the best solution, but thought a macro may be the only way as Test.xls will be used by several people, whereas Test2.xls will be a document that all other people copy data to.

Hope that's clear.

[royUK]

You don't need VBA as i thought.

There's not enough data for a proper test, but adding a contractor in the table of data for the first number, displayed on the form this formula works

=VLOOKUP(I8,[Test2.xls]Sheet1!$B$7:$P$28,4,0)

The formula will update without you needing to open the data workbook

Currently you need to clean up the form to use by removing the data validatio 7 possibly the code

[RobAndrews]

I don't think I wrote my initial query clearly enough when re reading it.

I want to send the information the other way than the answer proposes.

Test holds information that primarily will be keyed in by the user. Once finished, certain pieces of information will be sent to Test2 (acting as a register).

The reason I think a macro is required is because I may have 2 or 3 users working in a local version of test and writing the information back to the same Test2 workbook. Therefore I need the information to be sent over and then fixed (copy&paste values I guess), then when the next user registers their's it'll go into the next available record.