AUTO FILL TABLE if a specific sheet is selected from list box

Hi I'm a newbie who just joined the Excel Forum.

I work at a securities company and I have to manage clients' allocation and commissions for all IPOs we participate in.

I have attached the excel file that I am currently using.

Here are some of the things I would like to get it to work:

1) Create a list box in a worksheet called, 'Allocation Report' and if a specific worksheet is chosen, i.e. 'A', then the table in the red box is filled with data from worksheet 'A'

2) Create a list box in a worksheet called, 'Commissions' and if a specific worksheet is chosen, i.e. 'C', then the table in the blue box is filled with data from worksheet 'C'

3) A new row is added/deleted in both worksheets 'Allocation Report' and 'Commissions' if an account with allocation is added in worksheet 'A,' B,' or 'C'

I tried doing this using VBA, but I'm not anywhere close to getting this done.

Please help!!!

Hi fryon1031,

Welcome to the forum!

Nice question with perfect explanation of the requirement.

Please check Allocation Report.

I have used the formula

Formula:

Please Login or Register  to view this content.

with the List Box control.

Let me know your feedback, if this is what you are looking for.

Regards,
AM

Thanks so much Ashish! This is what I exactly needed!

Repped!

Peter

Hi Peter,

Thanks for nice words. Glad it worked for you.

Welcome back any time!

Please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved.

Regards,
AM

Done. Thanks!