Help Copying Data From Closed Workbook Using Input Box

[Smith369]

Good Morning,

I have two Workbook's Quick Test1.xlsm(Source) & Test.xlsm (Destination) , i would like to have a button on the Test.xlsm Sheet "Master" that once clicked prompts user to search for a client name, it will then search the closed workbook Quick Test1.xlsm Sheet "Companies" for the client name once found pull the entire row for each entry that matches through to the Test.xlsm Sheet "Master" excluding two columns G & H.

Both workbooks are in the same folder "C:Test\"

Workbooks Below

Kind Regards,

 

[vletm]

1st sample
As You wrote, Copying data from closed WorkBook using Input Box'.
That means 'Source' will / have to be closed all the time.
1) There is a link that You have to update then You first time open 'master'.
2) Press 'DO IT'-button and write needed 'Client Name'.
>> Ideas, questions?

 

[Smith369]

Vletm,

This is absolutely fantastic , could you explain to me how I create the link between workbooks ? So I can repeat this on other projects ?

Thanks very much again , really helpful and quick response.

 

[Smith369]

And secondly how would I then change which column it searched within for example if I wanted a button to search "Project No" or "Project Name"

Thanks again for the help, really appreciated