Copy rows of data to another sheet if a cell in that row contains a date within a range.

[dan653]

Hi All,

I'd be very grateful for your help here....

I have a quotation log, with information a table... with columns from A to Q - in a sheet called Quote Log - BQH
Each week I must run a report with all new quotations and I have therefore set up a sheet called Summary and there is a start date (Cell H7) and an end date (Cell O7)

What i'd like to do is, copy all rows from the quote log that have a quote date (column C from Quote Log - BQH) into a new sheet called New RFQ's

It seems so straightforward but I cant figure out the formula.

Then taking it one step further - I've also made sheets called Won and also one called Lost - and I want to copy the data as above but only if the quote has been won into the won sheet or lost into the lost sheet. Won/Lost is listed in the Quote Log - BQH in column O.

 

[XLfriend777]

Hi dan653 - You might consider filtering the columns so that your could easily filter on column C for all rows that contain dates. Then you could copy those to the New RFQ sheet. Sorry if I don't completely understand your problem, but I thought this might help get your thread started. Good luck!