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\"
Can post the workbooks if this helps at all.
Kind Regards,
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\"
Can post the workbooks if this helps at all.
Kind Regards,
