Thread
:
financial spreadshee
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett