Excel Find then post to new worksheet

[Sareimer]

Hello All,

My Excel workbook has approximately 40 worksheet all structured in the same manner. I am looking for a way to select all worksheet to find a certain keyword in a column/row. If found I would like to copy each of those rows and paste into one new master worksheet.

Any suggestion is welcome.

Thanks,
Stephanie

 

[johnwm]

Try the Office forum forum68 or the VBA forum forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[fredericofonseca]

for code for the copying bit you can look at thread68-803961


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com