Import Data from External Workbook to Specific Cells in Destination Workbook

Hi gurus,

Refer to the attached to better understand my requirement.

Raw DB.xlsx
Form (Macro-Enabled).xlsx

I developed an Excel tool that will populate a form in a sheet "Form (Macro-Enabled).xlsx" by importing data from the external workbook "Raw DB.xlsx". I was able to pull it off (without using the loop function) until the user requested to have the output to be arranged in a certain way. With the new form layout, a simple xlUp method won't do the trick.

I will appreciate your help guys, and thanks in advance for all your inputs.

Originally Posted by ykobure

I developed an Excel tool that will populate a form in a sheet "Form (Macro-Enabled).xlsx" by importing data from the external workbook "Raw DB.xlsx".

Hi, you forgot to attach the code you have 'developed'. By the way 'xlUp' method still works with your attachment …

Hey @Marc L, I did not attach the tool I initially developed since I believe the new direction is completely different from this one. But should you wish to check, here are the macro-enabled files. Thanks in advance.

Quotation Tool (sample).xlsm - The form
DB to be imported.xls - The database to be imported.

By clicking the "IMPORT QUOTATION" button on Page 2 of 3, the table will be filled out with data.