Forum Discussion
How would I pull data internally through sheets and sort it onto different pages?
1) I can technically erase the "Priorities" tab and just have all of my information on one page?
Example: Just have the data validation pull everything from the "Core" tab and I could erase the "Priorities" tab.
2) How would I update the range of data validation with each project that I add to where its drawing information from?
My only questions would be:
1) I can technically erase the "Priorities" tab and just have all of my information on one page?
Example: Just have the data validation pull everything from the "Core" tab and I could erase the "Priorities" tab.
Not only can you do so, I'd recommend having only the one source for data.
2) How would I update the range of data validation with each project that I add to where its drawing information from?
Ah, the magic of Excel Tables. In this new one, I have eliminated the Priorities tab, so it's drawing from the Core. And I've also eliminated all the empty rows from Core. Now, here's the magic: add a new row, with a new manager, and see what happens to the data validation list. I've already added two new names to demonstrate.
Unless I'm mistaken, you should be able to copy your entire original database into Core and see the list magically updated to include all of the unique names......and the sheet with Filter will work with any of them.
You need to modify the formula in Cell A7 of the Selected Priority sheet, the very first argument there...basically by "re-selecting the entire table from Core (not the heading row, but ALL the rest).
=FILTER(Core_2,Core_2[Manager]='Selected Priority'!B2,"None found")
The part I've highlighted in bold above. Highlight it in cell A7, then select all of the table in Core. And hit enter. The formula will still read the same, but it should work.
Your sample had included only those limited columns. If you can't get it to work, see if you can now attach a file to the bottom of your message, or, if not possible, go back to sharepoint and let me know.
- Did you use a new name? And did you select that name then in the Selected Priority sheet? I just tried it and it worked just fine.
- Thank you!!! I believe I know how to handle everything else but, I'll ask just in case.
When I tried to add a row to the "Core" sheet, it didn't copy over to the selected priority sheet. How would I go about doing that?