VBA to copy data with no cell identifier

[MrCrimmy]

Hi All,

I am having a lot of trouble with a particular spreadsheet I'm trying to develop. It's a project tracking tool and what I need to do is copy and past all the late projects into a specific sheet for review with our dept heads which is quite laborious. I am trying to find someway to copy an entire row of cells dependant on one cell and past it into the second work sheet entitled 'Late Projects'.

This is how each project is displayed:


[TABLE="class: cms_table"]
<TBODY>[TR]
[TD]Project[/TD]
[TD]Project Subheading[/TD]
[TD]Assigned[/TD]
[TD]Created[/TD]
[TD]Due[/TD]
[TD]Completed:[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Project 1A[/TD]
[TD]John[/TD]
[TD]01Nov14[/TD]
[TD]20Nov14[/TD]
[TD][/TD]
[TD]LATE[/TD]
[/TR]
</TBODY>[/TABLE]


So effectively I need to scan down through, pick out the lates and copy all the info seen above into a second sheet.

Can anyone provide any help here? I undrestand the basics of <ACRONYM title=vBulletin>VB</ACRONYM> but I am unsure of how to do this without telling which specific cells to copy and which to paste to. It also doesn't have to use a macro either that was just my approach

I hope that was clear

Thank you

Bryan​

 

[SteveO59L]

Why not use a filter, then copy+paste?

 

[MrCrimmy]

My boss likes to over complicate things haha!