Copying specific strings from several worksheets to a new worksheet

[Omega3k]

Hello,

I'm pretty new to Macro Programming so I hope that I'll be able to explain myself well enough and that someone will be able to help me.

Here's what I need to do... I have a workbook with several worksheets. I need to copy all strings between quotation marks in one particular column, (in my case, Column J), of every worksheet into a single column of a new worksheet, and the worksheet name where the string was copied from in another column.

For example, say cells J2:J3 in Worksheet1 contain: "Bla bla bla "This is what I need to copy 1" bla bla bla "This is what I need to copy 2" bla bla bla." and cells J2:J3 in Worksheet2 contain: Bla bla "This is what I need to copy 3" bla bla bla "This is what I need to copy 4" bla bla bla.". I need cells A2:A3 in the newly created worksheet to contain: "Worksheet1", cell B2 to contain: "This is what I need to copy 1", cell B3 to contain: "This is what I need to copy 2", cells A4:A5 to contain: "Worksheet2", cell B4 to contain: "This is what I need to copy 3", and cell B5 to contain: "This is what I need to copy 4". I would prefer if the quotation marks were removed when copied to the new worksheet. I need the code to do this for every sheet in the workbook.

Can anyone help me out with this? Any help is greatly appreciated!

Thanks a lot!

[pike]

Hi Omega3k
welcome to the forum.
It a very interesting question, can you attach a small zipped example workbook?