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!