search and copy certain cells.

[guidom]

I have a file with two worksheets.
Want to search if some values on worksheet NEXT OVERVIEW can be found on a row in worksheet OVERVIEW. if so then certain cells from overview must be copied to next overview.


See attachment.

Thansk

Guidom
search and copy certain cells.xlsm

[tim201110]

See attachment.

[guidom]

Thanks, i will take a look at that.

Guidom

[guidom]

Tim201110,

I think your dutch, because of the index formula.
I'm too, so that was handy.

The index doesn't work, the first worksheet overview is in my file a sheet where all the data is from an index formula. If i use your formula in my file the cell stays empty and i'm sure there is a value. Any idea.
The AG column is not from a index formula also the A, B and C column are not from an index.

I found it, my worksheet names has a space in it. I enclosed the names in ' that worked.