[Pic 1 - Workbook 1 where data is selected and where dropdown with slip numbers should be] (Pic 1 - Workbook 1 (Dropdown Slip Numbers))
[Pic 2 - Workbook 2 where slip numbers are found with site addresses but are randomly sorted](Pic 2 - Workbook 2 (Data))
Please can someone help me.
I have 2 workbooks each with a working sheet.
From workbook 1, I need to insert a dropdown in column Slip Numbers that displays the slip numbers just for the Site Address selected in Site Address column. Then when the same site address is selected in any row below, it will display the site addresses available (minus the ones selected above)
The data for the dropdown is found from Workbook 2, but is not sorted or synchronized, but does correlate with a particular site address.
[Pic 2 - Workbook 2 where slip numbers are found with site addresses but are randomly sorted](Pic 2 - Workbook 2 (Data))
Please can someone help me.
I have 2 workbooks each with a working sheet.
From workbook 1, I need to insert a dropdown in column Slip Numbers that displays the slip numbers just for the Site Address selected in Site Address column. Then when the same site address is selected in any row below, it will display the site addresses available (minus the ones selected above)
The data for the dropdown is found from Workbook 2, but is not sorted or synchronized, but does correlate with a particular site address.
Last edited: