Pulling from one sheet to another based on date

**faxmebeer** · 12-31-2009, 12:01 PM

I'm building a personal budget that looks a lot like a set of business financials (really just an exercise to learn excel techniques).

So, I have one sheet that acts as a register -- in column A I have the date of the transaction, column B is the amount, C is from which account the money came, D is the use of the money, and E is a code (1 for paycheck, 2 for investment income, 3 for food expense...etc).

On another sheet I have an income statement. I want the income statement to pull code 1s from the register sheet for the month indicated by column A in that sheet into the proper month column (B is january, C is Feb....). I then have a cash flow sheet which uses V-lookups to pull the information from the income statement, and that seems to work fine.

I'll include a copy of the file I'm working on for reference (all numbers are completely made up).

**dcgrove** · 12-31-2009, 02:50 PM

in your example sheet I changed the code to the actual type of transaction it was to match your transaction types in column A. this will make it easier to copy the formulas down the columns in your income statement as it will reference the cell in column A. i would also reccomend naming the ranges you will be using on the register tab for ease of inputing these formulas. I put a couple of sumifs formulas in column N so that you can build on them. If you have any questions about them, let me know!

Clayton Grove

**faxmebeer** · 12-31-2009, 04:37 PM

Originally Posted by dcgrove

in your example sheet I changed the code to the actual type of transaction it was to match your transaction types in column A. this will make it easier to copy the formulas down the columns in your income statement as it will reference the cell in column A. i would also reccomend naming the ranges you will be using on the register tab for ease of inputing these formulas. I put a couple of sumifs formulas in column N so that you can build on them. If you have any questions about them, let me know!

Clayton Grove

Worked great, Clayton, thanks so much! I changed the dates to "<=" in order to pick up those dates that happen to fall on the first or last days of the month, but asside from that it's perfect!