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!

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!