reading data from excel / vba help

[halobender]

Hey guys.. Need some ideas for gathering some information from a closed workbook. I currently have a script that will open a workbook gather information and paste to a set area in a new workbook then close, however i need to edit this to do the following.

search column B for text string over 5 characters if > 5 characters then copy all rows (until reaches a blank row) from colums A-Z and paste to sheet 1 AA1 in workbook running macro.

search column B for (next) text string over 5 caracters if > 5 characters then copy all rows (until reaches a blank row) from colums A-Z and paste to sheet 2 AA1 in workbook running macro.

on and on and on.. i am thinking a loop will work great but unsure how the search and copy / paste will work.

Any and all ideas much appreciated..

 

[SkipVought]

Hi,

Take a look at the Find method.

Skip,

_[red][/red]