Forum Discussion
How would I pull data internally through sheets and sort it onto different pages?
2) Yes this is all going to be in one workbook
3) CK is the person's abbreviated name--So essentially, each employee will have their own "priority page" and that will tell them what to work on each week. There will be a total of about 11 pages, but as our employee numbers grow, so will the sheets in the documents.
4) As far as the information on the big picture, it was all entered manually and as it updated on the first picture, it would update onto the second. The document would be on our company server so everyone would have access to it if needed (14 of us).
I don't really know how to answer the other questions you asked because I'm still a novice when it comes to excel.
1) Thanks for the helpful information, I just removed the images!
Thanks for doing that so promptly.
3) CK is the person's abbreviated name--So essentially, each employee will have their own "priority page" and that will tell them what to work on each week. There will be a total of about 11 pages, but as our employee numbers grow, so will the sheets in the documents.
And will that data on each employee's page simply be listed in much the same way as on your first or second sheet, just sorted or selected based on priority? i.e., will you be expecting a simple extract of data as is, or are you thinking of a different kind of display? If so, how?
I don't really know how to answer the other questions you asked because I'm still a novice when it comes to excel.
I wasn't asking Excel questions: I was asking what I'd call "business process" questions. Think more what the process would be without Excel: what are the business purposes, the management or supervisory purposes being served. Let those of us with excel experience translate.
Finally, if you could create a "dummy" version of the workbook as it is, could you post it either to Google Drive or OneDrive so that I or others here in the https://techcommunity.microsoft.com site could take a look, that would be VERY helpful.
Just make sure it's representative of the real one, but has Mickey Mouse or Darth Vader or any of their colleagues as the names.......
- Here is the link I just created: https://moodyengllc-my.sharepoint.com/:f:/g/personal/rjones_moody-eng_com/EkW2yJ5sQB1MooGJc2ZR5rQBrITKBlWquKqvlm2G3hphqA?e=ImcUQm
P.S here's a good video on FILTER (assuming you do have the most recent Excel)
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?