There is a database of contractors with assigned products in Sheet1.
How to make a button with a selection list in Excel VBA so that after selecting the appropriate contractor the data in Sheet2 will be filled in in the following form:
- column B1 - contractor's name
- column B3 - listing all products assigned to the contractor in Sheet1 one below the other
an example sheet in the attachment
How to make a button with a selection list in Excel VBA so that after selecting the appropriate contractor the data in Sheet2 will be filled in in the following form:
- column B1 - contractor's name
- column B3 - listing all products assigned to the contractor in Sheet1 one below the other
an example sheet in the attachment