find and copy
 

Help please

I have a worksheet in excel that has 1000 records in it, 100 column
wide as follows:

Col A = ID#
Col B = Equipment
Col C = Dimension
Col F = Ser #
Col G = Location
Col J = Recall Date
Col K = Status
Col Q = Recall Date

The columns that I haven't listed don't contain information for thi
question, and there are 8 more columns with recall dates as well.

What I am wondering if it is possible to do is to search through th
various recall date columns for a specified date (or range of dates
and copy the data from the columns above (or the entire row if that i
easier) to another worksheet in the same workbook.

Oh, I also need it to look at the status as well. If I were going t
use filters, I would set the Status to "Active", and then select m
first Recall Date column, find the date(s) I need, copy and paste thos
rows, select all with the autofilter in the first recall date column
go to the next and and repeat.

I'm hoping there is a way to do this with code and automate it a bit.
The new data copied to the new sheet doesn't have to be saved, it i
for a one time use only, but this would have to be done at the start o
each week/month.

Thanks for any help anyone can offer

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com