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 pull only the active tabs results into another tab I use for billing that is within the same workbook.
I am tired of having to write all the basic information again into each billing tab I have to do when it could just be all copied from the main quote tab.
For Instance: The dates on all the trip quotes are in the same cells - Trip start is in C3 & the trip end date is in D3. If I hide all of the quote tabs I am not using and only have the quote I am working on unhidden, how can I make sure the date gets transferred to my billing page which would be in cells: Start - E3 & End - G3?
- mathetesSilver Contributor
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.