Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 21 December 2017
  0 Replies
  2.3K Visits
0
Votes
Undo
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)
2017-12-20.png
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.