Transfer data to new workbook

[pjdevlin]

I have a workbook to collect and display data, on a monthly basis. The data for each item appears in blocks of 8 consecutive rows. Some of this data needs to be transferred to a new workbook for the following month, whilst some needs to be ignored. Does anyone know how this can be done without manually copying and pasting each data block into the new workbook?

[6StringJazzer]

It can be done. Everything depends on what's your data, how is it formatted, and how you decide what is transferred and what is ignored.

From your brief description I'd conclude that it is probably necessary to use VBA. It would be ideal if you attached the workbook and described how you want the transfer to work.