Copy row if Date match.

[Gazou]

Hello,

I have this great macro but it was used to copy row that matched TEXT value.

I have other similar need but I want it to look for a date value instead of text.

My problem is problebly this: If (level = "")

But cant figure out what to replace it with

Any sugestions ?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

It would assist if you also uploaded the workbook.

[Gazou]

Here is the document.

If I try: If (level = "dd-mmm-yy")

The macro goes nuts and crashes.

Hope someone can help me out

Thanks in advance.

Eric

[AB33]

It is illegal( )to use / as a name in excel. You might assume that the code was working, it aint't. It has an error trapping which means, it ignores the error.
Your code requires lots of improvement, but for now, just do these two lines.

Please Login or Register  to view this content.

[Gazou]

They were fake names for me but I guess they could exist somewere in this world lol

thx that fixed that error, but now it disregard if colonm confirmed is y or n.

[AB33]

Gazou,
I am not sure I understand what the issue is. The code you have creates tabs for each value in column A and copies that row in to each tab. You have 5 data in the master sheet, 4 of these were copied in to 22-Feb and the other one in to 12-feb. Column Y/N has been copied. You need to show the out put you desired.

[Gazou]

It was looking if Colunm "F" was active then copy if not active go to next row. It's my bad, I needed it to look in Colunm "E"

Please Login or Register  to view this content.

Thx alot for your help, much appreciated