I want to set up ac accounting system in excel. However i want to be
able to have a check register and a cash register worksheet, but i want
to be able to do the following:

when i type the date, vender, account, and price into the checkbook
register i want that whole row of info to tranasfer to another
worksheet that is just for that vender. How do I do This? and How do i
set up my checkbook to do this for each vender for the month.

thanks