Excel Query Needed

[NonStopLeo]

Modification to the attached excel sheet that uses Microsoft Power Query as follows. Keep all functionality working with these modifications. Employee Schedule Sheet- Option to sort by trade I would like the option to sort by trade then jobsite then alphabetical… Also dates should remain in Monday, Tuesday, Wednesday, Thursday, Friday, Saturday order, and relist the Job EACH Day. This will help when I guy is moved back and forth from a job mid week. Dashboard Sheet- It would be beneficial to DISPLAY the Manpower needs by trade on any given bar without going through and selecting all the projects that have Pipe, Sheet, or Plmb after it. For instance can they have their own COLOR of the bar. So all jobs that end with SHEET can be totaled, all jobs that end with PIPE can be totaled and would stack ontop of the bar with SHEET, same with PLMB. So we can see how much of each bar is PIPE vs PLMB vs SHEET. Same thing with Potential Projects, Break this bar into the three trades. On the Current Projects Page. I would like a tool developed that would allow for quick copying of the previous week assignments forward. For instance take all the assignments made on date 05/04/18 and copy that forward for a period of time that can be selected by the user, as an example it could be Monday through Friday (Or Saturday if needed) for the next six weeks. A couple clicks and this is accomplished.

File is given in below link

https://jumpshare.com/v/FeTu9V3ZeKOy5LtrfC4e

 

[Alice Morland]

Leo, in my opinion, you're not asking for an answer to a question, but for someone to do a complex query for you based on one long paragraph without one single 'please' in it... I doubt anyone will do the work...

Instead, why not try to do what you can and ask for help on that piece of query that doesn't work (if any)? Just my two cents - not trying to be conflictual here.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1229405-excel-query-needed.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.