Hello There,
I have 2 workbook files (attached sample workbooks):
1. Master File 1.xlsx (1st file)
2. Entry File 2.xlsm (2nd file)
- The 1st file stores all the master data records across various worksheets (Customers, Vendors, Currency, etc) .
- In the 2nd File the User references (read only) the master data from the 1st file.
Eg. Currency Code and Names:
Userform
In the 2nd File, a Userform is created where it displays selected columns from the master file worksheet Table in a object ListView. The User selects a row and the required values are displayed in the worksheet cells. It also has a search field. As the User type, the records are filtered with the typed string in the ListView
W/o Userform
Other option, the User enters a Currency Code in cell E7. The program should retrieve it's corresponding 'Currency Name' from the 1st file and should display it in cell G7. If it does not exist it should display a message.
I have attached the sample files for your reference. From my little understanding I have included some code which is not completely working.
The User does not want to use the standard Data Validation and would like to have it work in the above manner for a broader functionality regarding this requirement.
Could you please have a look at the attached files and advice how the above can be achieved?
Many thanks for your help. Look forward to hearing from you.
Regards,
Don
I have 2 workbook files (attached sample workbooks):
1. Master File 1.xlsx (1st file)
2. Entry File 2.xlsm (2nd file)
- The 1st file stores all the master data records across various worksheets (Customers, Vendors, Currency, etc) .
- In the 2nd File the User references (read only) the master data from the 1st file.
Eg. Currency Code and Names:
Userform
In the 2nd File, a Userform is created where it displays selected columns from the master file worksheet Table in a object ListView. The User selects a row and the required values are displayed in the worksheet cells. It also has a search field. As the User type, the records are filtered with the typed string in the ListView
W/o Userform
Other option, the User enters a Currency Code in cell E7. The program should retrieve it's corresponding 'Currency Name' from the 1st file and should display it in cell G7. If it does not exist it should display a message.
I have attached the sample files for your reference. From my little understanding I have included some code which is not completely working.
The User does not want to use the standard Data Validation and would like to have it work in the above manner for a broader functionality regarding this requirement.
Could you please have a look at the attached files and advice how the above can be achieved?
Many thanks for your help. Look forward to hearing from you.
Regards,
Don