Hi there,

I was hoping somebody might be able to help me with an issue I have.

My spreadsheet has two tables, one of which includes an entire list of transactions. The second only contains some of the transactions from the main table i.e. it does not have any transactions that do not appear in the 'main' table.

Up until now, the second table has been populated by copying and pasting certain entries from the main table to it but I am trying to automate this process.

Both tables start with the same column headers. They are as follows:

Date Invoice Number Customer Country Description Net Value Per Invoice Currency Exchange Rate Net USD Value Code


The first table starts in Cell A13 and the second starts in A20. The second table is actually the main table. I am trying to achieve the following:

- The column entitled 'Code' has a drop down list to select a code for the transaction.
- The list of codes is stored in a separate sheet called Codes
- There are 22 codes in the list. If any of 13 of the 22 are selected, I want the entire row to be populated in the table which started at cell A1.
- The codes are in F2:F23 of the sheet entitled Codes. It is the last 13 of these in a row which I have referred to above.
- Ideally I would like this to automatically update without even running a macro. Perhaps I could build in a refresh.all macro that runs anytime a cell is changed to trigger this.
- I have no way of knowing how many entries will be in either table so I need the smaller table to just add a row each time the criteria is met.
- So effectively, I want a live duplicated table which is filtered...


Any ideas?

Thanks in advance!