Copying rows of data depending on the data type in a column

[mels]

Hi everyone

New to this forum, and excel programming. I have had a good look for this solution but my apoligies in advanced if something like this has been answered before!

Basically I need some kind of vba code that will find and copy particular rows of data in my spreadsheet 'Sheet 1' to a different location such as 'Sheet 2' depending on the type of data in column A. Column A has a mixture of headings, integer values and timestamps. Timestamps are in the format dd/mm/yy hh:mm:ss.000. Column B can contain, headings and a range of numerical values (floating point, integers etc).
So in a nutshell I need to extract the actual information in the output of data in 'Sheet 1' by copying it to another location and 'Sheet 2' will have the copied rows.

The actual information is in the rows where column A is a timestamp or when column B is a numerical value.

I have used code similar to the one below to find particular values but I am completely stumped as to how to do this with a something like a timestamp or let it find particular data types if this is possible.

Please Login or Register  to view this content.

Thank you

[arlu1201]

It would be good if you attach a sample workbook. It will help you get a solution faster.