Budget spreadsheet
 

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

Budget spreadsheet
 

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

begin he

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

Budget spreadsheet
 

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 he

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