Forum Discussion
I want to send data across two workbooks depending on the condition explained below.
Sorry but its the business requirement that it has to be like this.
Source workbook is available for all the members of team but Destination workbook is accessible to higher management only.So THAT is the answer to the question Patrick2788 asked; not the bit about "a lot of other data." Still doesn't really explain a separate tab for each day, but if that's the way it is (inefficient) that's the way it is.
I've attached samples of how INDIRECT can work with your situation. As noted above, however, be forewarned that INDIRECT uses a lot of resource as a "volatile" function
Sorry but its the business requirement that it has to be like this.
Source workbook is available for all the members of team but Destination workbook is accessible to higher management only.
Also the Source workbook which i have provided shows only the UI part, but in actual the values are being automatically populated on the basis of formulas applied on source workbook.
Sorry but its the business requirement that it has to be like this.
Source workbook is available for all the members of team but Destination workbook is accessible to higher management only.
So THAT is the answer to the question Patrick2788 asked; not the bit about "a lot of other data." Still doesn't really explain a separate tab for each day, but if that's the way it is (inefficient) that's the way it is.
I've attached samples of how INDIRECT can work with your situation. As noted above, however, be forewarned that INDIRECT uses a lot of resource as a "volatile" function
- Great, thank you so much for this.
Also considering your suggestion i won't be using it directly in master sheet now.
Thanks again 🙂