Code to copy values to formula's in other sheets

[Miehjs]

Dear clever Excel people,

I would like to be able to have values automatically copied to another sheet into a specific cell and then added to the formula that's in that cell.

I'll explain why I want to be able to do this:
I use sheet 1 as a long list to where I always add my expenses. Sheet 2 and 3 etc. are specification sheets of my expenses. For instance, sheet 2 is expenses on the car. In sheet 2 I have different sections, for instance: gas costs. When I add a number that I spent in sheet 1, I would like that number to add up to the number that is in sheet 2 in the cell 'gas costs'. But only ofcourse when I command the number to copy to that specific cell, because I am also adding other numbers, for instance; money spent on laundry.

Do I have to use macros for this?
If yes, could someone explain to me how this works?

Kind regards,
Michelle

[JBeaucaire]

I wouldn't do any of that. Sheet1 should list all your items in a single reference database.

DATE
DESCR
CATEGORY
GROUP
AMOUNT

Once you have that, you can create a Pivot Table to give you totals on any category or group you want, no additional sheets needed.

[Miehjs]

Thank you for your reply.
I chose this lay-out because I want to see all my expenses per day, but also per category in other sheets.
So what I have at the moment is:
Sheet one has the description and price of what I bought per day and sheet two has per month the total costs per category.
Will a pivot table still give me that same clarity? (I am just asking before I am going to change my complete works.. )

[JBeaucaire]

Once you build a simple DB like I've described, select all the data, then INSERT > PIVOT Table.

It's hard to explain until you get in and start playing with Pivot Table features. The flexibility is phenomenal. From that one set of data you can create as many dynamic Pivot tables as you want representing data any way you wish. Costs per item, costs per category, costs per month...

You can Google pretty much any variation you want and get instant examples.... "Excel Pivot Table Costs per month"... etc.