0
Undo
Votes
i use excel to record my daily expenses, i have sheets named after each month (jan, feb... dec) and then categories in column A (health, food, trips, car, etc...) and the days of the month across row 1 (1,2,3,4,5...31)
can i create a macro or something where i can have first cell has a list of the months, second cell has a list of the categories, third cell has a list of the days, and the last is where i manually enter the expense amount, then hit a button and that would first, match "first cell value" and then "second cell value" then "third cell value" and takes "fourth cell value" and records it there?
if for example, i had selected SEP, HEALTH, 4, 50 the macro would first locate sheet SEP, go down column A to find HEALTH then across to day 4 and then record 50.
i know its a tall order... but it doesnt hurt to ask.
thank you
Abdulaziz
can i create a macro or something where i can have first cell has a list of the months, second cell has a list of the categories, third cell has a list of the days, and the last is where i manually enter the expense amount, then hit a button and that would first, match "first cell value" and then "second cell value" then "third cell value" and takes "fourth cell value" and records it there?
if for example, i had selected SEP, HEALTH, 4, 50 the macro would first locate sheet SEP, go down column A to find HEALTH then across to day 4 and then record 50.
i know its a tall order... but it doesnt hurt to ask.
thank you
Abdulaziz
There are no replies made for this post yet.