• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comparing dates

D

dotchieJack

Member
Hello dear helpers,
I have a worksheet with multiple coloms with dates (from F to P).I am looking for a code that checks if one of the dates will expire within 30 days and copys the values of colom A and B and value of F to P of that row to another worksheet
Lets say in Row 3 de date in colom G expires within 30 days than i schould get in the second sheet Value A3 Value B3 And Value G3 or if the date in colom G and P expires within 30 days than I should get Value A3 B3 G3 P3 in the other worksheet. If I run the code again, if the entries already exist in sheet 2 the values should not be copyed again and the new entries should be added under the existing ones
 
I've used it many times today.
What do it do? ... anyway, do it gently.
Or
Could You use another browser?
 
You must log in or register to reply here.
Back
Top