• 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.

Copy data between selected dates to other sheet2

aamirsq

Member
I have a Master_sheet with lot of data column D is DATE ([$-409]d-mmm-yy;@) & column G is (=D-today()). In O1 date ([$-409]d-mmm;@) & R1 date (=DATE(YEAR(O1),MONTH(O1)+3,DAY(O1))-1).


I want is when i date any date from O1 (drop down list). Only column A, B, D, E & F data which falls between these two dates (O1 & R1 should be displayed to sheet2?


How i do it? macro!!
 
Aamirsq


Firstly, Welcome to the Chandoo.org forums.


Have you considered using either an Advanced Filter?


Posting a sample file will make it easier to assist.

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
Back
Top