financial spreadshee

[Kristie Cobb]

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!

 

[Don Guillett]

You can do this with a worksheet_change event that uses select case to place
the entry.