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.

--
Kind Regards,

Dan

1. start with a good template
2. add your macro front-end

begin here:

http://office.microsoft.com/en-us/te...dget&av=TPL000

then update this post after you have made your choice.

--
Gary''s Student - gsnu200856


"Dan" wrote:

> 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.
>
> --
> Kind Regards,
>
> Dan

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...

--
Kind Regards,

Dan


"Gary''s Student" wrote:

> 1. start with a good template
> 2. add your macro front-end
>
> begin here:
>
> http://office.microsoft.com/en-us/te...dget&av=TPL000
>
> then update this post after you have made your choice.
>
> --
> Gary''s Student - gsnu200856
>
>
> "Dan" wrote:
>
> > 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.
> >
> > --
> > Kind Regards,
> >
> > Dan

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.




In message <EFCA5732-9BA4-4343-B4E6-(E-Mail Removed)>, Dan
<(E-Mail Removed)> writes
>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...
>

--
Nospam