Userform.listbox populate when dates expire

[jmaocubo]

Hello everyone.
I ask for help in developing a project.

1) I have a userform with one listbox;
2) I have two "Test1" and "Test2" worksheets;

In Test1 I have:
Column C - Project code
Column D - Project Name
Column G - Project start date

In Text2 I have exactly the same information as Text1 but in column "I" has the date of revision of the project

Problems:

Problem1: I need to populate userform.listbox1 with the information on columns C, D and G from sheets ("test1") if date in "G" is (<) then now.
Problem2: If project code in test1 exist in test2 (same code- Column C) and date in "I" different from blanck/empty or revised date (>) now, then ignore in the userform.listbox1 the project entry of sheet( "test1")
Problem3: While maintaining the assumption of problem 2, If the date of the skipped projects (e.g.workbook open in another day) is (<) now, then the entry of that project (s) are displayed in userform.listbox1 from test 2

Thanks in advance for all the help you can give me.
Miguel

[AlphaFrog]

Perhaps you could attach an example workbook with all the components and example data.

I don't follow problems 2 and 3. Please elaborate.

[jmaocubo]

Perhaps you could attach an example workbook with all the components and example data.

I don't follow problems 2 and 3. Please elaborate.

Hi
Thanks for the replay.

After reading your replay, I understood that I was complicating the project.
I can do everything from the same worksheet.

Can you help me?
attached example

Thank you in advance.

Miguel

[AlphaFrog]

Please Login or Register  to view this content.

[jmaocubo]

AlphaFrog thank you so much
It worked very well and I've already added it to my remaining code!!!!

Thanks again.

Miguel

[AlphaFrog]

You're welcome.