Copy paste data with certain criteria

[garyaps]

Hi

I am new here and need a little help.. I cant seem to figure out how I can copy and paste data with a certain criteria (the date). For example if Sept 5 is on c1 then the copied data needs to be in c2

 

[sgmpatnaik]

@garyaps

Welcome to Chandoo.org group, glad you are here

please upload a sample file with you desire requirement.

There is lot of tricks to use the copy and paste method with VBA and Formula also.

Thanks

 

[garyaps]

sgmpatnaik

Here is the file, basically I need the data in sheet raw range M4 to M52 copied on the data tab below the correct date which for that example is sept 7.

 

[garyaps]

already figured it out