Autofil and list out today task

[impresxy]

Hi,

I need help on my file. I have 2 sheets; sheet2 lists all the task no. which will be more that 4000 records and the date in each column(year). I would like to have a macro code that can autofil only the task no. that has today date in its row and list them out in sheet1 so it shows the task my users have to do today. In addition, if the date falls in Saturday and Sunday, can it shift and list out on the Monday next to that weekend?

[:) Sixthsense :)]

In A2 Cell - Array Formula Requires CTRL+SHIFT+ENTER

Please Login or Register  to view this content.

Drag it down...

[impresxy]

Hi again Sixthsense,

Thank you so much for your response. I have tried your formula but I cannot see the list of the task with today date on A2. It just shows blank. Would it be possible that you can give this as a macro code? I am afraid my users will accidentally delete this formula as they are not familiar with excel that much. And to be easier for the users, I would like the code to be able to to continue the list in Sheet1 columnA without blank, for example if there are 10 task with today date so it only list out these 10 in A2 to A11.
Thank you very much Sixthsense.

[:) Sixthsense :)]

Because there is no task is available for today

You can protect the Column-A and leave the rest for user access.

If you need VBA solution only then please let me know

[impresxy]

Hi,

I have tried to change the date to be today but still there is nothing happen. So sorry for my stupid, may be I do not understand it that much so I made something wrong. If you would please see my picture
Sheet1.jpg
Sheet2.jpg

It would be very nice of you, if you could give the VBA?

[:) Sixthsense :)]

Refer the attached file for reference

[impresxy]

Hi again Sixthsense,

The formula you given is working now. I think I have done something wrong with it so I create new file and do the same again. It's now list out very nice.
Just for the sake of some further VBA I have to put in. I still would like to ask for your kindnest for the code to make this application run using VBA please ?

[impresxy]

Opps,

Sorry I was writing when you are posting the previous one.

[:) Sixthsense :)]

Please wait I am writing the code for you

[impresxy]

Very nice of you

[:) Sixthsense :)]

Try this code...

In Sheet2 you are having a hidden column (column-B) just delete it before running this code

Please Login or Register  to view this content.

[impresxy]

Wowww this works really great. Thank you so much for all your help.
Can I ask one question, What if i need column B do i need to change something?

[:) Sixthsense :)]

What if i need column B do i need to change something?

Just have a Header in B1 cell thats enough

Thanks for the feedback too...

[impresxy]

Thank you so muchhhhhh

[impresxy]

Hi Sixthsense,

Sorry for interrrupting you again. I have tried to put the today date in other column, it appends that the list in Sheet1 doesnt show the task that list with today date in other column. I want to be sure that if I come to next or next to next year, will this code working still ?
Thank you so much.

[:) Sixthsense :)]

It means that you will be having duplicated Year headers am I right?

[impresxy]

Yes, just in case..

[:) Sixthsense :)]

What needs to be done when the same task # fall for both columns

[impresxy]

Umm, lets say one task has date today in column B and the other task has date today in column C..
But when one task has 2 column the same date, we just list out that task as one.. sorry for confusing you

[impresxy]

Hi Sixthsense one more time.,

I really need your help badly... based on the VBA code you have given, can you please help to modify it to also list out the task in Sheet1 if that task (sheet2) date is older than today this year and column C is blank?

Always thanks for your help and kindness,..

Please Login or Register  to view this content.

[:) Sixthsense :)]

and column C is blank

I am not clear about the above (new) condition

[impresxy]

Can you please see my file attached. I now make column C as a status update of my task list. So if my user has listed out the task today, and they do not finish one of them, this column will be blank on that undone task. Then I would like tomorrow, when the list shows up, to list out the task that has not done today. In addition, this will help if the task falls in Saturday and Sunday. (Please dont laugh at my vba code and thought, I only have little knowledge about this :P)

[:) Sixthsense :)]

I am unable to understand the logic how I know that the task is completed or not from the base for populating the incomplete task for the next day.

I slightly changed the Thisworkbook code and the E2 cell hyperlink formula. Now you can click the E2 cell which will locate it to the concerned cell.

Please clarify me the above requested detail to proceed further.

[impresxy]

Thank you so much, Sixthsense..

My file will be opened by my user every morning. They will see the list of all today tasks. When they finish the work, for example task one listed in first sheet. They have to change status update to be "Done". After the day is finished, they click button "Save Today Work". I have a code to send the status to the sheet2 and the status will be "Done".

Now if there is one of the task today has not been done, my user will not change the status. and the task's status will be blank. Then, I would like the code to be able to catch this task tomorrow from the blank status. Which means, when the date in sheet2 of any task has the date earlier than today in this year and the status is blank, it shall be listed in the task list sheet 1.
Please let me know if any explanation of mine is not understandable.
Thank you very much for your time.

[impresxy]

Hi Sixthsense,

I understand that my question is like a mess.I am sorry I have tried with my ownself and i come up with this code, I just want you to see if this is a good code or you may have any suggestion. I always thank for your help. It makes me come this far..

Please Login or Register  to view this content.

[:) Sixthsense :)]

Yes the code is perfect to my eyes

The reason for delay in responding the thread is I was little bit confused about your requirement and due to some task given to me at my work place. Anyhow I am glad that you managed to fix it

[impresxy]

No worry at all. THis is very nice of you. It's me that have to say sorry for interupting and thank to you for the first code. I really have this work done now..

[:) Sixthsense :)]

No issues