Hi,
I'm trying to use the "Combo Box (Form Control)" pull-down menu to list customer names (B8:U8) which I have going across a row on a separate worksheet tab, and underneath this I have specific data regarding costs being listed.
I want to make a summary frontpage on a separate worksheet tab where by using the "Combo Box (Form Control) pull-down menu it will automatically pull the information from the "data" tab and populate the fields with the data for that customer.
I have both tabs in the same exact layout/format; so I'm guessing a Vlookup or Index/Match could be used along with the "Combo Box (Form Control) to pull the right information.
Can anyone help me with how exactly I could get this working properly?
Thank you!
I'm trying to use the "Combo Box (Form Control)" pull-down menu to list customer names (B8:U8) which I have going across a row on a separate worksheet tab, and underneath this I have specific data regarding costs being listed.
I want to make a summary frontpage on a separate worksheet tab where by using the "Combo Box (Form Control) pull-down menu it will automatically pull the information from the "data" tab and populate the fields with the data for that customer.
I have both tabs in the same exact layout/format; so I'm guessing a Vlookup or Index/Match could be used along with the "Combo Box (Form Control) to pull the right information.
Can anyone help me with how exactly I could get this working properly?
Thank you!
