I have a file that consists of a number of tabs: "Data Entry" "Chequing" "Savings" and "Credit Card"
The first tab is a data entry worksheet. All the data entered in it is entered by hand on this sheet.
The data in the Data Entry Worksheet consists of a date column, vendor column, description column, chequing account column, savings account column, and credit card account column.
Each row in that table corresponds to a single transaction that impacts one or more of those accounts (i.e. an "expense" amount would appear in one of those columns; a transfer between accounts would have amounts in two of those columns).
I then want to take that data that has been entered by hand, and automatically transfer it to corresponding Chequing, Savings, and Credit Card registers in different tabs. I don't want to re-enter all that data by hand in the specific account register; i want it to populate automatically in those other registers.
How do i do that?
I know it involves VLookup, but I can't figure out how to do it without resulting in blank rows in the account registers corresponding to transactions that did not have an amount in that specific account's column in the data entry worksheet.
I have attached a sample worksheet with sample data so that you can see what I mean.
Thank-you
Bookmarks