On 20 Apr, 08:44, "sali" wrote:
"Stuart" je napisao u poruci interesnoj
oups.com...





On 20 Apr, 07:55, "sali" wrote:
"Stuart" je napisao u poruci interesnoj
oups.com...

There may be some confusion

I have two sheets full of data in each column.

Copying one column and comparing is not what I want exactly.

I want the macro to look at one sheet and then look down the other
sheets columns to check if the string is contained within that
column. The the string from the other sheet is a contained then for
the macro to extract a cell in column K of the same row that had a
match and then copy it to the end of another sheet.

Does this make sense?

as usualy the problem is in undersztanding between peoples!
to write a macro, you need 5 minutes, to understand a problem, you need 5
hours!
just to make it clear:

how many much columns "down the other sheets columns"?

to "copy it to the end of another sheet" does it mean append to the bottom
of the leftmost column at the "third" sheet?- Hide quoted text -

- Show quoted text -

Hi

This will make it slightly easier to comprehend.

The macro should:

Look in sheet 2 column A and then search for the string in sheet 1
column A. If found then insert a row and copy the row from sheet 2
into sheet 1.

I will make sure the columns match back. This should allow me to work
the way I want.

Thanks