Forum Discussion
How would I pull data internally through sheets and sort it onto different pages?
OK, I was able to download that sample file. Thanks!
Here (attached) is one example of a system that could work. This does use a couple of brand new functions--UNIQUE and FILTER--that require the most current version of Excel, so if it doesn't work for you let me know. I've put a few comments in to help you understand what I've done....
I'm off on an errand momentarily, so any further work from me will have to wait till later this afternoon.
- Thank you so much! 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.
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.
- 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?