Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Have "L" column display the task, dates and color on the second box.

Posted on 2016-11-02
22
Medium Priority
?
61 Views
Last Modified: 2016-11-04
Hello there Expert Exchange community,

---Wanted to have any assign task with dates that are from the "L" column on the second box that is located on the page called (SHEET 1)
---Please have all of the task shown in groups of color ( for example; if i have task for today shown on the (GENERAL SHEET)
1 yellow
2 red
1 blue
1 green
1 yellow
1 green

Have them appear  All Green being on top of all color then all red, then all blue and last all yellow.

2 green
2 red
1 blue
2 yellow

Same theory with the Tomorrow and Future Days group.

Second box will be displaying all task that have the task in three separate rows.  


****TODAY***** = Only task that are schedule for today.

****TOMORROW**** = Next day

****FUTURE DAYS****  = Days that does not includes today or tomorrow but task that are assign in two days from now and further on.

1st.png28974603b.xlsm
0
Comment
Question by:Omar Hernandez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 11
22 Comments
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41870897
The workbook you attached has just the GENERAL worksheet. The other two are missing.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41870903
It's a workbook from some time ago.
0
 

Author Comment

by:Omar Hernandez
ID: 41870911
sorry about that, here you go Marty
28980395.xlsm
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 49

Expert Comment

by:Martin Liss
ID: 41870920
Is the password still "Omar"?
0
 

Author Comment

by:Omar Hernandez
ID: 41870922
yes
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41871018
I'd like to use a feature that is only available in Excel 2010 and later. Is that a problem?
0
 

Author Comment

by:Omar Hernandez
ID: 41871039
sounds good
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41871219
I've run into a problem and that is that while I can manually color a part of a shape, I need to find out how to do it programmatically.
0
 

Author Comment

by:Omar Hernandez
ID: 41871371
is it possible Marty to have the (NUMBER BUTTON) to when there is a color used for a task have the title of the color input to column "O" for example on task on date "10/31/16 WHY IS IT IMPORTANT TASK"

It to displaying in "RED" to help it differentiate it from the total of four color have it input in column "O" word (RED)

When the second box located in (TO DO SUMMARY) have it go through first as a bridge to the "O" column find the color it will be display and get the rest of information of the due date and task name.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41871373
I think I may have solved the problem.
0
 

Author Comment

by:Omar Hernandez
ID: 41871375
nice
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41871377
Yeah you pound away at something long enough you can beat it into submission:)
0
 

Author Comment

by:Omar Hernandez
ID: 41871384
ha ha,, lol
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41872684
Try the attached. The list shows up when you refresh. Currently it's a little slow because I'm looking at the data on the GENERAL sheet 8 times (2 periods x 4 colors = 8). I may be able to speed it up but I want to make sure that what I've done so far is what you want.

I changed the color of one of the shapes so that the blue todo's can be read.
28980601.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41872723
Looks very good, only have two things to have to make it right on point, but as i  said so far looks awesome.

1st.png
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41872733
I can do green first. Is the desired order green, red, blue, yellow?
0
 

Author Comment

by:Omar Hernandez
ID: 41872948
yes
0
 

Author Comment

by:Omar Hernandez
ID: 41874987
any luck my friend
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41874994
I thought you might be wondering:) I'm still working on it. It's very tricky.
0
 

Author Comment

by:Omar Hernandez
ID: 41874997
yes i had a felling it would have been one of those moment with this function. Thanks for always making it possible with previous question and looking a way around the challenging task.
0
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 41875065
Here you go.
28980601a.xlsm
0
 

Author Closing Comment

by:Omar Hernandez
ID: 41875114
Really neat wrapping up the end result, thanks again Marty appreciate your expertise
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With User Account Control (UAC) enabled in Windows 7, one needs to open an elevated Command Prompt in order to run scripts under administrative privileges. Although the elevated Command Prompt accomplishes the task, the question How to run as script…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question