Hi,

This is my first post. I've found many very useful bits of information on this website in the past but this task has beaten me - so far.

I have a growing workbook containing operational data over 24 columns. Column H contains dates and column T contains comments and is about 90% blank. i need to copy all the rows in a date range (month) which contain a comment and paste them into a new workbook. One month usually has between 30 and 40 operations but there may only be 3 or 4 comments. Ideally I'd like end users to be able to choose a month and year from a drop down box in order to generate a new workbook with just the 3 or 4 rows of comments.

Many thanks in anticipation.

Tookey