Budget spreadsheet

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi Gurus,

I would like to learn how to create a basic macro budget worksheet. I wanted
a macro that can prompt me to enter date, description and amount with
formatted cells in date, texts and values respectively. and commands it to
insert a new row in according to date order (and within a certain row range).
Can you provide an attachment with a macro examples, i can follow and
practice.
 
Hi Gary,

Thank you for your help...

Similar to a Personal budget sheet. If I may describe quickly as to what I
plan to do.

Basically, just trying to keep track of my account balances eg with the
following heading, Dates, Description (of expenses), Bank A (as an examples),
Balance, Bank B, Balance, across the column.


I hope this helps...
 
Thanks everyone.

I used the formula =SUM(F4,D5)-N(E5)

to solve one problem the value error was coming from a cell the had a
formula in it that wasn't correct when one of the cells it was using was
empty.

Thanks for the pointers in the right direction.
 
Back
Top