Hi all,

I have started to learn about the world of Macros and I need help with a project I want to do for myself (for my own financial and curiosity benefit)

I am currently recording all of my expenditure for the year so I can see how much I am spending and potentially create myself a budget. I have attached an example file of what I am doing. example.xlsx
I have created my own rudimentary expenses sheet divided by month, date, day, item, item in detail, store,location, cost, sub total at the end of each day and then the tax i pay on each item. I also have set each day to have a border height of 4 columns, the first one to be the date, the next two columns will contain and items I buy and the last one contains how much I spend that day and I have it also set up so that I can collapse each day into a group so I can see how much i spend each day without having to see what i bought at the time. In the second sheet I have done similar but here I want to include them in a table which will allow me to see what I bought over all the months in the year so far.

At the moment I have manually copy each days expense into sheet 2. What I would like to do is to have it "automated" via a Macro so when I input an expense into a day, all i need to do is hit a shortcut button and it automatically put the expense into sheet 2.
I do no know if this is possible considering some days I would have no expenses while other days I could have 5 or 6 items which means I would need to the 4 columns bigger.

Is it possible and not too complex to do?


Your help would be grateful

Stephen