Forum Discussion
Only Use Unhidden Tab Results
I have multiple tabs available with each tab being a different quote/invoice. Depending on the customers choice of trip will determine which tab I use to quote. I want to know if there is a way to ...
I want to know if there is a way to pull only the active tabs results into another tab I use for billing that is within the same workbook.
Yes, there is a way. There probably are multiple ways. If you want to work to resolve it yourself, you might find the INDIRECT function helpful.
But without seeing what you're describing, it's very difficult to give specifics that would apply and be easily grasped.
You could help us help you by posting either a copy of your actual workbook or a mockup that faithfully represents the actual (but, as a mockup, contains no proprietary data), putting it on OneDrive or GoogleDrive with a link here that grants access to it.