This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
That is currently how I do it. However, this actual process is repeated multiple times throughout my workflow (other spreadsheets that have multiple tabs) and hence I am rereading the same workbook over and over and over and over. I am wanting to clean up the workflow and eliminate the redundant data tools.
For example I have one workbook with about 20 tabs. I then need 20 data input tools for the joins I do with that one particular workbook.