Lists

[csharma84]

Hi

I hope you guys and girls can help.

I am creating a template for some colleagues. In the template, the user will select an account from a drop down list (say the list is in A1). Then a few lines below (A5-A50), any sub accounts which relate to the account selected will appear. So it's like a dependent list but I don't want the sub-accounts to be in a drop down. Also If I subsequently choose another account, it should remove the sub-accounts that are shown and then list the sub-accounts for that new account.

Can anyone help? My colleagues think I need to use VBA but I'm not familiar with it so unsure where to start.

Thanks in advance

 

[Momentman]

VBA should be your best bet. Why don't you want a drop-down list for the sub-accounts? well, where do you have your accounts and corresponding sub-accounts listed

 

[shg]

If you have account and subaccounts in different columns of the same table of data, you could just use autofilter.

 

[csharma84]

As I'm not familiar with VBA, I would prefer to avoid using it.

Let me explain my problem in more detail, it might help with finding the solution. I am working with the finance team at my company. The finance team load the monthly accounts from SAP into a reporting system (HFM). There is a relationship of many SAP accounts to 1 HFM account. I need the finance team to reconcile their data using the HFM account. So in the template, I want the user to select the HFM account that needs to be reconciled and below it will populate automatically the SAP accounts and the balance of the SAP account. I have the mapping table in a separate sheet in the file.

I hope that helps to set the scene. Appreciate the help!