logo elektroda
logo elektroda
X
logo elektroda

VBA Excel: Create Button with Selection List to Extract Contractor & Product Data in Sheet2

rrafix 3330 1
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 16379022
    rrafix
    Level 12  
    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
  • ADVERTISEMENT
  • #2 16379076
    kinggustav
    Level 27  
    First, make a macro that works the way you want. Leave the button for the end. How to prescribe you probably know? If you don't know, record some rewriting. Then you can connect this macro to the button. There is only a small detail: You write about copying the data of a single contractor, so either each contractor must have its own button, or after pressing the button you have to somehow select the contractor. This is also possible and with the use of the available dialogues, even not that difficult.
ADVERTISEMENT