Forum Discussion
filter participants in different tabs
Hi, I'm trying to use the "participant" sheet to manage who will come to this event. I'm using 0 or 1 in the "participant" sheet to track their need for flight/meal/hotel. If there is a 1, then the ...
What you wish to do simply won't work with Excel formulas or, indeed, any other functional programming environment. The flight data, for example, must either be on the corresponding row to the participant table or linked by matching the name.
Once the input tables are linked you could then filter the results to build a separate report.
The alternative is to use an imperative style programming language such as VBA but even then there is good chance of losing data by toggling the {0,1} on the participant sheet.
Thanks for the explanation. Now I get why it is not working. Could you please kindly help me with the VBA macro code at your convenience?