Excel Help

[Shikkaka]

Hi all,

I have an Excel spreadsheet with all my finances on. I have a 'Finances' worksheet that details the whole year and any certain payments which are being paid. I then have 12 other worksheets for each month.

When I have paid a certain bill I colour the relevant cell so I know it has been paid. I have set it up so all the monthly worksheets use the 'Finances' worksheet to calculate what money I have left.

What I would like to do is enter all the certain payments in but for the monthly worksheets not to deduct them until I fill them in with a color.

Is this possible?

Thanks

 

[Paul. W]

Yes its possible.

Have a look here:
http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

You need to insert a new macro as a Module. Really easy to do. Once done, you make a new formula using the new module, allowing you to add the total value of cells depending if they are color filled or not.

Only downside to this, is that when you have it setup, and to add or remove the color fill to a particular cell within the range, the total will NOT automatially update like a normal sum function does. You have to refresh it.

 

[Shikkaka]

Thanks for the quick reply. I'll give that a go.