Apologies if this has been covered already - my search for prior posts turned up nothing.
Excel 2002, SP3
I have attached a simple file to explain what I am wanting to automate. The file includes 3 tabs: JAN, FEB, GASOLINE. The JAN and FEB tabs include transactions for those particular months. The 3rd tab, GASOLINE, is what I am trying to automate. I would like a way to search through the JAN and FEB tabs and copy all of the rows that have "gasoline" as the category to the GASOLINE tab. I have manually created the table on the GASOLINE tab as it should be - I am looking for either VB code or formulas (preferred) to automate the process. In the real spreadsheet where this will be implemented, there will be 12 tabs to sort through (one for each month). Also, I would like for the GASOLINE tab to continuously update whenever new transactions are entered on the JAN and FEB tabs.
Thanks in advance for any help with this.
Bookmarks