Need to select all cells in a workbook over the value of 1200 and paste to new worksheet

[meadsie]

Hi

I am looking for the VBA to select all cells on column "Q" on multiple worksheets that are over the value of 1200 and paste them with the corresponding name of the worksheet they are found in, to a new worksheet.

For example

NEW SHEET

Sheet 1 1200
Sheet 2 1234
Sheet 3 1400

Could anyone please possibly help?

Many thanks

[jmac1947]

Hello meadsie,

as usual, someone is going to say post a sample workbook with input and expected outputs, a workbook is worth a thousand words they say and i agree

It also helps the volunteers on the forum (that is all of us) get a flying start to solving your issue

Jmac

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.