Forum Discussion
Display specific tables based upon cell value
Looking for a way to capture/display either a table or series of set columns, followed by specific # of rows based upon a specific selection. I have a series of tables on its own independent she...
Hello,
I'm afraid I can't picture what you are trying to achieve. Can you upload a small data sample and manually put in the desired results? Then explain the logic that leads to the result.
Hi and thank you for your follow up question.
What I'm trying to do is if on an independent sheet\tab within a workbook, is that if a cell = a table #"/30 or /29 or /28" ect... that it would take tone of the below tables and populate it exactly on the new sheet, if the cell reference is blank no table is displayed. I tried doing a vlookup, but that can only take me so far, I need the exact # of rows to grow based on what table is referenced. or any other way to make the rows grow based on the selection.
