Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a spreadsheet to budget | Excel Worksheet Functions | |||
A bit confused on my budget spreadsheet. | Setting up and Configuration of Excel | |||
conditional sum for budget spreadsheet | Excel Worksheet Functions | |||
help with personal budget spreadsheet | Excel Worksheet Functions | |||
Inheriting spreadsheet from another user for budget analysis | Excel Discussion (Misc queries) |