Automatically filling tables (creating lines if necessary) with data, using a formula ?

[KomicJ]

I'm currently working on a stock management tool in Excel, that would require a bunch of tables to be filled with data from the main transaction list. I'm pretty sure VBA is the only way to go to achieve that, but thought I'd ask, just in case one of you guys had a few tricks up your sleeves. I'm attaching the document to this post (I listed a bunch of stocks to make it easier for you to see).

So basically, I have all the transactions listed in a table called "ADVActuel" on the first tab (called ADV Actuel). It lists the stock general infos (columns B:G), Initial transaction infos (columns G:K), Current stock value (columns L:O), Previous month comparison (columns P:S), Closed transaction infos (columns T:X) and dividends (columns Y:Z). I have it setup so that once you enter a selling date (column T) and selling price (column U), all the data from L:S will disappear, replacing them with "".

That works well. Now here's the tricky part.

If you take a look at column F, it lists the different folios (for the purpose of this exercise, I called them Picsou, Fundoc and Star ADV). As time will go by, that transaction list will be quite long...so I created four other tabs, called "Folio - Combinés", "Folio - Picsou", "Folio - FunDoc" and "Folio - Star ADV" where I'd like to list only the open transactions (so either with data in column L:S, or with blanks in T:X) for each specific folios (so those with "Picsou" in column F would be listed in the table on the "Folio - Picsou" tab, etc.)

The "Folio - Combinés" tab would list only the open transaction, regardless of the folio.

To make matters even more complicated, I have four stocks symbols that shouldn't be included in any of those list (ZUB, IYF, ZUH and IHE) as they have their own unique tables already.

IMPORTANT: The different tables in each individual folio pages (ie. "Folio - Picsou", "Folio - FunDoc", etc.) are already programmed. So I don't need to whole line to be copied, I would just need the stock symbol (column B in ADV Actuel) to be written in column C of those pages. The table will fill itself after that, once the symbol is entered.

Now like I said, I'm pretty sure this can only be achieved by a VBA macro (which I'm not good enough in to even think about doing). But I thought I'd ask anyway.

To anyone with an input on the matter, a huge thanks !

KJ