Excel/ VBA: Problem with Search Results

[SBuzzT]

I am trying to do a search for a value across several sheets in a workbook. If the search value is found, it returns 2 of the columns on the sheets along with the sheet names.

I have modified some code from another project I worked on, but I can seem to get the search results to display correctly. If the search value shows up on only 1 sheet, it looks fine, but if it appears on several sheets, I get a new row for each instance, with only the last row looking the way I want it to with all the data I need. (see linked example.)

I'm completely stumped at this point and almost out of time. Any ideas?

 

[SkipVought]

hi,

Company security disables downloads.

Please post your example at forum707 directly along with your code.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SBuzzT]

Done. Thanks, Skip