I was sent a spreadsheet with three year's of data. The document is broken down by accounts and within each account are rows with transactions that took place for all three years worth of data. For example:
Cash
2009 ... ... ... ... ... ...
2009 ... ... ... ... ... ...
2010 ... ... ... ... ... ...
2010 ... ... ... ... ... ...
2011 ... ... ... ... ... ...
and so on and so forth for multiple accounts. I would like to create a separate sheet with just the information from 2009. Is there any formula or method I could use to pull all of the rows for each account from the year 2009?
Cash
2009 ... ... ... ... ... ...
2009 ... ... ... ... ... ...
2010 ... ... ... ... ... ...
2010 ... ... ... ... ... ...
2011 ... ... ... ... ... ...
and so on and so forth for multiple accounts. I would like to create a separate sheet with just the information from 2009. Is there any formula or method I could use to pull all of the rows for each account from the year 2009?