VBA to copy data with no cell identifier

MrCrimmy

New Member
Joined
Sep 26, 2014
Messages
14
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​
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top