Ok, I have looked around for weeks now to try and find this. I have a workbook with several rows of bills due that month. The columns include the amount of the bill, when it is due, and the category of the bill (utility, loan, insurance). Those category options are in a drop down menu. What I would like is for a second sheet to be created with a breakdown of the categories. All the utilities in a table or listed, all of the loans listed, and all of the insurance bills listed, along with the amount due and due date. So basically when I type in a bill and pick the category, the table on the second sheet automatically fills with the information I just entered depending on what category of bill it is. Please help! Will post a sample if necessary
Bookmarks