?
Solved

Have information from one page show up on another

Posted on 2016-10-29
24
Medium Priority
?
39 Views
Last Modified: 2016-10-30
Hello there Experts Exchange community. I would like to find a way to input an information from a page and for it to display the main task and when it is done, show the one that are not done, clearing out the one that are dealt with.

Examples are given on the following pics... Thanks again for your help and time...

1st.png
2nd.png28979725b.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
  • 13
  • 11
24 Comments
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41865877
I'll see what I can do.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41865924
1) If for example "Study" was checked on the 28th but not today, should it show up in today's Daily To Do list?

2) There are two sections in (rows 11 to 23 and rows 24 to 37) on the Daily To Do sheet. Do I need to be concerned about the second one?

3) Can either section grow?
0
 

Author Comment

by:Omar Hernandez
ID: 41865937
Yes.

Let's say that yesterday being 29 was checked it will be clear out on the box.

but when the actual date move to the next date and the column which meet the row that says "STUDY" and is not check, show it on the box.
0
Industry Leaders: 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: 41865952
I don't think you answered question 2 and 3. Maybe you didn't see them since I edited the question.
0
 

Author Comment

by:Omar Hernandez
ID: 41865954
2) There are two sections in (rows 11 to 23 and rows 24 to 37) on the Daily To Do sheet. Do I need to be concerned about the second one?

I would like to have the first section mainly show up (11 to 23)

And when the first section is all done.

automatically show the second part (24 to 37)


3) Can either section grow?
 ---can i have an example to understand better?
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41865967
3) There are 13 tasks in the first part, could there ever be a 14th in that part? There is currently room for nine items in the second part. Could there ever be a 10th?

I assume it's your family in the picture. Very nice.
0
 

Author Comment

by:Omar Hernandez
ID: 41865978
Thanks,

ok first part being 13 will not grow and for the second part being 9 will not grow.

for the first part where 13 task are

would like it to recognize the order that i check off, so that what ever i finish checking last on the daily to do.

On the next day, show it to be on the first line
what ever i finish on second to last, show it to be on the second line
and so on.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41865981
In addition to the above I have another question. How are you planning to add the checkmarks? One easy way to do it is to set the font to "Wingdings 2" and enter a "P" when you want a checkmark. With your permission I'll change the font in ranges F11:R23 and F29:R37.
0
 

Author Comment

by:Omar Hernandez
ID: 41865982
Sounds great
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41865983
would like it to recognize the order that i check off, so that what ever i finish checking last on the daily to do.

On the next day, show it to be on the first line
what ever i finish on second to last, show it to be on the second line
and so on.
I may be able to do that but it won't be easy. Can we leave it for a new question?
0
 

Author Comment

by:Omar Hernandez
ID: 41865988
sure, would do that.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866017
Daily tasks..
28979819.xlsm
0
 

Author Comment

by:Omar Hernandez
ID: 41866160
Hey there Marty, would appreciate if we can get it to where it hides the second group and when all the first group is done automatically show the second group.

---If i need one more to check on the first group, show the second group once the last task is checked
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866167
If you like I can also make it so that instead of having to enter a "P" in the cell to see the checkmark, all you'd need to do is select the cell and the checkmark would appear,, and if the cell already has a checkmark it would become blank. Let me know.
0
 

Author Comment

by:Omar Hernandez
ID: 41866169
That would be even a better option, thanks for the suggestion.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866181
BTW I noticed that columns G, I, K, M, O, Q and S on the Daily To Do List sheet aren't visible. Are they used? If not do you have any plans for them?

 
would appreciate if we can get it to where it hides the second group and when all the first group is done automatically show the second group.

---If i need one more to check on the first group, show the second group once the last task is checked
I'm also not sure what that means. I think it means that rows 25 to 38 should be hidden unless there is something in every cell in C11:C24 (By "C" I mean merged columns C:E) but in that case I don't understand what being done has to do with it.
0
 

Author Comment

by:Omar Hernandez
ID: 41866214
BTW I noticed that columns G, I, K, M, O, Q and S on the Daily To Do List sheet aren't visible. Are they used? If not do you have any plans for them?

---no i don't have nothing in mind

I'm also not sure what that means. I think it means that rows 25 to 38 should be hidden unless there is something in every cell in C11:C24 (By "C" I mean merged columns C:E) but in that case I don't understand what being done has to do with it.

---what i mean by this is show first group this being task row on (11-23)
  Only show the first group first on the (SHEET 1) show only the task in between 11 - 23 row

---Once all the task from the first group are checked off 11 - 23.
  Display the second group from row between 29 - 37 on the (SHEET 1) same place where group 1 is displayed, but second group will only be display when the first group is done ( check off)
0
 
LVL 49

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 41866236
Check this out.
28979819a.xlsm
0
 

Author Closing Comment

by:Omar Hernandez
ID: 41866250
This feature is running great. What i just wanted plus more... Thanks again Marty
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866252
You're welcome. In the next question please describe the following in more details.
would like it to recognize the order that i check off, so that what ever i finish checking last on the daily to do.
On the next day, show it to be on the first line
what ever i finish on second to last, show it to be on the second line
and so on.
For example are you talking about changing the order on Daily To Do List sheet or on Sheet1 (which we should probably give a name to)?
0
 

Author Comment

by:Omar Hernandez
ID: 41866255
(SHEET 1) will recognize what was the last task done and for next day will display it on the first line, the second to last that was checked off it will display it on the second line and so on.

Daily to do list sheet will stay the same as it is.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866261
Please consider this example using only three tasks (task1, task2 and task3) and they appear in that order.

1. They are created today and none are completed
2. If I complete task2 today what is the order today?
3. What is the order tomorrow?
4. If today I also complete task1 but after task2 what is the order
5. Given the above if tomorrow I complete task3, what is the order
0
 

Author Comment

by:Omar Hernandez
ID: 41866263
1. They are created today and none are completed
2. If I complete task2 today what is the order today?
3. What is the order tomorrow?

---task 1 first line, task 3 second line and task 2 last line.

4. If today I also complete task1 but after task2 what is the order

---task 3 first line, task 1 second line and task 2 last line.

5. Given the above if tomorrow I complete task3, what is the order

For the next day.
---task 1 first line, task 2 second line and task 3 last line.
0
 
LVL 49

Expert Comment

by:Martin Liss
ID: 41866264
OK, I think I've got it, thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

770 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