Pulling Specific data that meet certain criteria from main workbook into new workbook

Hi all,

I've been stuck a few times and the guys here have always been super helpful.

I'm trying something a little more complicated now, I hope I can make myself clear

I have a fairly simple spreadsheet, each record relates to an issue we have logged. The spreadsheet current is logging everything since April of this year.

How can I extract specific data into a new workbook, like so:
1. Pull all record between (for instance) 1-05 and 31-05 in the date column, and move those records with the data from columns (for eg) a, b, d, e and f into a new workbook

2. Have the new workbook refresh it's contents from the original workbook, so that when it is updated, the extracted data also updates, (to avoid having to update two spreadsheets instead of one).

If I've explained this clearly, it should be obvious that what I'm trying to do is create a summary of each month, and save that into a new, (but continuously updated) workbook. If that's not clear, I've made a pigs ear of my explanation.

I'd be grateful for any advice,

(or calls of "what are you talking about?" too)

Thanks

A macro seems more appropriate. Try posting in the programming folder (either move this thread over there, or note that you have posted the question in another folder if you do move it though).

I did wonder about that, thanks.

I don't know how to move threads around, or if I have the permissions to do that, so I've re-posted in the programming thread, as advised.

Cheers!