Find the date and copy the values from the colum of the date find and paste to other sheet

This doesn't necessarily need VBA. You could enter into sheet 2 A1:

Please Login or Register  to view this content.

And copy down? This should give you all results provided you copy the formula down far enough. The ranges (A:E) will need to be expanded if you plan on having more dates.

Obviously this will update every time the date changes... so if you want a copy of each day, then VBA will be necessary. But if you only want the report for today, then this will work.

Originally Posted by nizzcmzph

What will I do if I have dates from A1 to AC1? What would be the formula for it? I'm getting wrong output. P Lease help me!

Is this what you are looking for?:

Please Login or Register  to view this content.

It might be better and run faster if instead of having the TODAY() function in the code, you reference one cell that has =TODAY() in it. Like so:

Please Login or Register  to view this content.

Hope this helps.

Originally Posted by nizzcmzph

Attachment 215315Still cant get it i attached again a new sample. Please help me! Needed it so badly. TIA
name2

Here you go:

Please Login or Register  to view this content.

Enter into A1 and copy down. This should now work.

Hope this helps.

Originally Posted by nizzcmzph

#N/A is the result

That's because today is 20/02/2013 and you have no results inputted for this date?

OK if you feel that this issue is solved, then please use the thread tools at the top to change the topic title to solved.

Don't forget to leave feedback if I helped