Hi. I am making a membership loans and contributions system and I have 13 sheets. Jan-December and a summary sheet.
I would like the user to select a member name in dropdown#1, select month from dropdown#2, and input desired amount on textbox#1
So what happens is, If I select member#1, month of July, and enter $1000, the system will automatically encode that on the corresponding 'July' sheet. I don't have any idea how to use the cell search query on excel.
Also, I would like the amount to be added e.g. if member#1 has existing $1000 contribution, it will be =1000+1000
Thank you in advance!
I would like the user to select a member name in dropdown#1, select month from dropdown#2, and input desired amount on textbox#1
So what happens is, If I select member#1, month of July, and enter $1000, the system will automatically encode that on the corresponding 'July' sheet. I don't have any idea how to use the cell search query on excel.
Also, I would like the amount to be added e.g. if member#1 has existing $1000 contribution, it will be =1000+1000
Thank you in advance!