Jump to content

Excel Expenses Help

Matsy
By Matsy
in Off Topic
 Share
Posted

Not sure where to put this.

I want a very simple excel document where I have a drop down box where I select the month and it populates a table below the drop down with w/e I spent that month (ofc i fill this in daily)

Also want this to be able to update a CURRENT BALANCE field next to the table dynamically with my current balance.

 

Basically select January, table changes to jan, select feb changes to feb etc

PC SYSTEM: Fractal Design Arc Midi R2 / i5 2500k @ 4.2ghz / CM Hyper 212 EVO / Gigabyte 670 OC SLI / MSI P67A-GD53 B3 / Kingston HyperX Blue 8Gb / 

WD 2tb Storage Drive / BenQ GW2750HM - ASUS VE248H - Panasonic TX-P42ST60B/ Corsair AX750 / Logitech K360 / Razer Naga / Plantronics Gamecom 380 /

Asus Xonar DGX / Samsung 830 256gb / MEDIA : eMachine ER1401 running OpenELEC XBMC with Seagate STBV3000200 3TB Hard Drive - Panasonic TX-P42ST60B

Link to comment
https://linustechtips.com/topic/251518-excel-expenses-help/
Share on other sites
Link to post
Share on other sites
Posted

You need a sheet with a table that has input and then next to it or on another sheet you create a pivot table: It will automatically summarize everything for you and divide and/or filter by month. 

 

Whatever you add to the input table will refresh on the pivot table, very simple.

 

EDIT: LOL you don't need a shit you need a sheet, sorry about that

-------

Current Rig

-------

Link to comment
https://linustechtips.com/topic/251518-excel-expenses-help/#findComment-3447545
Share on other sites
Link to post
Share on other sites
Posted
  • Author

Thank pivot table worked.

Another thing, I want to just keep the "input" table on another sheet and do everything from the sheet with the pivot table on...

Is there anyway to add information to the input table from another sheet by just filling in a row and hitting enter or something?

Like

Input location here: cost, type etc

Automaticlly update the table on another sheet

PC SYSTEM: Fractal Design Arc Midi R2 / i5 2500k @ 4.2ghz / CM Hyper 212 EVO / Gigabyte 670 OC SLI / MSI P67A-GD53 B3 / Kingston HyperX Blue 8Gb / 

WD 2tb Storage Drive / BenQ GW2750HM - ASUS VE248H - Panasonic TX-P42ST60B/ Corsair AX750 / Logitech K360 / Razer Naga / Plantronics Gamecom 380 /

Asus Xonar DGX / Samsung 830 256gb / MEDIA : eMachine ER1401 running OpenELEC XBMC with Seagate STBV3000200 3TB Hard Drive - Panasonic TX-P42ST60B

Link to comment
https://linustechtips.com/topic/251518-excel-expenses-help/#findComment-3451151
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Off Topic

×