Copying certain lines of data to another sheet

[Erusso]

Hey guys (& gals),

Little road block...looking for some insight

I am trying to bring certain data to another page. Basically I have a log of thousands of different events (as you can see I have used lines 6320 to 6323 as an example).
Anytime there is a line where "BRING FORWARD / À REVOIR" is selected from the drop down list in Column F, I would like the whole line to go to another page so that on the other page I will have a list of all the BRING FORWARD / À REVOIR events.

6320 2000-00-10 18:00 INFORMATION Sample information. CLOSED / FERMÉ Name
6321 2000-00-10 18:37 SHIFT START On duty CLOSED / FERMÉ Name
6322 2000-00-10 19:55 INFORMATION Sample issue. BRING FORWARD / À REVOIRName
6323 2000-00-10 23:50 SHIFT START Off duty CLOSED / FERMÉ Name

Can this be done?

Thanks

[benishiryo]

hi Erusso, welcome to the forum. it's better next time you upload a sample Excel file, otherwise there are many variables you might need to change since we have to assume many things. for this, i'm assuming:
1) Data in Sheet 1, column A
2) Output to Sheet 2 Column A
3) both sheets start in A2

Please Login or Register  to view this content.

those in red, you might need to change to suit your file

[rylo]

Hi

From your description, I think Advanced filter would be an option. Can you put up an example file so we can see your structure.

rylo

[Erusso]

How do I use this code?

[Erusso]

Also, How do I post an example file?