| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
financial spreadshee
I'm trying to create a 'check register' with budget worksheets where the
amount entered in the check register will automatically populate the appropriate budget page based on the entry type. Is that possible in Excel? Example: CR entry of 1400.00 with an entry type of 'Fixed' would copy to the debit column of the 'Fixed Budget' page (next available row). Hope to hear from someone! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
financial spreadshee
You can do this with a worksheet_change event that uses select case to place
the entry. -- Don Guillett Microsoft MVP Excel SalesAid Software "Kristie Cobb" <Kristie wrote in message ... I'm trying to create a 'check register' with budget worksheets where the amount entered in the check register will automatically populate the appropriate budget page based on the entry type. Is that possible in Excel? Example: CR entry of 1400.00 with an entry type of 'Fixed' would copy to the debit column of the 'Fixed Budget' page (next available row). Hope to hear from someone! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get a subtotal to appear in a column within a spreadshee | Excel Discussion (Misc queries) | |||
| how to increase the max number of rows in Excel spreadshee above 6 | Excel Discussion (Misc queries) | |||
| Can I set up a default footer that will appear in every spreadshee | Excel Worksheet Functions | |||
| List box or combo box on an Excel spreadshee... | Excel Worksheet Functions | |||
| How can I write vertically in some columns on an Excel spreadshee. | Charts and Charting in Excel | |||
Linear Mode
