I am fairly new to Excel and have only basic, limited knowledge on how to set up worksheets. I need some more help.
I have set up a workbook designed for tracking debt and finances. I use it monthly but some of my friends and family want to start using it as well. The way I have it organized is by lowest debt to highest. I then have the following pages to have the corresponding cells copy (or =) the box from the first tab. However, the categories or order of mine is not the same as theirs.
What I need to do is set up a way for the following tabs to be catagories. The information on these tabs will be predetermined from the first worksheet regardless of what row it becomes. I want to be able to resort the information on the first worksheet based in numerical order from lowest to highest once all information is entered. I then want the following tabs to also be completed with no more information needed.
Attached is a sample version of what I currently use. I entered basic information to show how it is copied throughout with only entering the information on the fist tab.
My hypothical is this: from the way I entered the information on tab one "Debt Overview" my smallest debts are my "School Loan 1" with a balance of $0 followed by my "Other" with a balance of $65. Now to arrange the list of debts lowest to highest I want to highlight the data in column D which is titled "Current Balance" ( would be cells D6 to D13) then hit sort 'smallest to largest' (a to z).
When I do the above it now changes what following tabs and mixes everything up so it is no longer in the right categories. For example, doing the above steps would put my "School loan 1" and "other" as debt on my "credit" tab and my "home loan" on my "misc." tab.
How can I set this up so that way no matter what order the information on Tab1 is entered my following category tabs are still correct?
Attached is the sample of the original workbook.