Hi,

I have two worksheets of data. I would like excel to be able to look
in two columns which contain different characters however they should
have a string of letters and numbers which are the same.

For example sheet 1 column A cell 1 may have ABC010456A and in sheet 2
column A ot may be CDA#010456A

I would want the find function to find what they have in common and
then copy the value for the same row but column i

Please someone help.....trying to compare over a 1500 rows is very
very very time consuming.

It's much appreciated.

Thanks

Stuart

is the cell position same on both sheets?
how long must be a same string to be considered the same sub-part?
is it allways the right ended part of cell?


"Stuart" je napisao u poruci interesnoj
roups.com...
Hi,

I have two worksheets of data. I would like excel to be able to look
in two columns which contain different characters however they should
have a string of letters and numbers which are the same.

For example sheet 1 column A cell 1 may have ABC010456A and in sheet 2
column A ot may be CDA#010456A

I would want the find function to find what they have in common and
then copy the value for the same row but column i

Please someone help.....trying to compare over a 1500 rows is very
very very time consuming.

It's much appreciated.

Thanks

Stuart

On 19 Apr, 14:10, "sali" wrote:
is the cell position same on both sheets?
how long must be a same string to be considered the same sub-part?
is it allways the right ended part of cell?

"Stuart" je napisao u poruci interesnoj
roups.com...



Hi,

I have two worksheets of data. I would like excel to be able to look
in two columns which contain different characters however they should
have a string of letters and numbers which are the same.

For example sheet 1 column A cell 1 may have ABC010456A and in sheet 2
column A ot may be CDA#010456A

I would want the find function to find what they have in common and
then copy the value for the same row but column i

Please someone help.....trying to compare over a 1500 rows is very
very very time consuming.

It's much appreciated.

Thanks

Stuart- Hide quoted text -

- Show quoted text -

Hi there

Thanks for the response.

I can place the data on the same column. It's not normally the case
but to get a solution to this then I will move the column.

The string will be more than 4 characters and I don't think it will be
more than 7.

I look forward to hearing from you,

Stuart

more important is the row() position of cells.
is the position row on the coresponding cells the same?
is the number of the cells the same on both sheets?

"Stuart" je napisao u poruci interesnoj
ups.com...
On 19 Apr, 14:10, "sali" wrote:
is the cell position same on both sheets?
how long must be a same string to be considered the same sub-part?
is it allways the right ended part of cell?

"Stuart" je napisao u poruci interesnoj
roups.com...




I can place the data on the same column.

Hi Stuart, What Sali is trying to explain is that we on this end cannot see
your worksheet, so to help us help you, you need to explain how your
worksheet is laid out. What data resides in which columns or rows, such as
part numbers in column A, description column B, etc. The when describing
what you want to do, for example, find part number xyz in column a and copy
entire row to sheet 2, row 6.
Then we on this end have an idea of what you are working with and how to
help you with your problem.

"Stuart" wrote:

On 19 Apr, 14:10, "sali" wrote:
is the cell position same on both sheets?
how long must be a same string to be considered the same sub-part?
is it allways the right ended part of cell?

"Stuart" je napisao u poruci interesnoj
roups.com...



Hi,

I have two worksheets of data. I would like excel to be able to look
in two columns which contain different characters however they should
have a string of letters and numbers which are the same.

For example sheet 1 column A cell 1 may have ABC010456A and in sheet 2
column A ot may be CDA#010456A

I would want the find function to find what they have in common and
then copy the value for the same row but column i

Please someone help.....trying to compare over a 1500 rows is very
very very time consuming.

It's much appreciated.

Thanks

Stuart- Hide quoted text -

- Show quoted text -

Hi there

Thanks for the response.

I can place the data on the same column. It's not normally the case
but to get a solution to this then I will move the column.

The string will be more than 4 characters and I don't think it will be
more than 7.

I look forward to hearing from you,

Stuart

On 19 Apr, 14:40, JLGWhiz wrote:
Hi Stuart, What Sali is trying to explain is that we on this end cannot see
your worksheet, so to help us help you, you need to explain how your
worksheet is laid out. What data resides in which columns or rows, such as
part numbers in column A, description column B, etc. The when describing
what you want to do, for example, find part number xyz in column a and copy
entire row to sheet 2, row 6.
Then we on this end have an idea of what you are working with and how to
help you with your problem.



"Stuart" wrote:
On 19 Apr, 14:10, "sali" wrote:
is the cell position same on both sheets?
how long must be a same string to be considered the same sub-part?
is it allways the right ended part of cell?

"Stuart" je napisao u poruci interesnoj
roups.com...

Hi,

I have two worksheets of data. I would like excel to be able to look
in two columns which contain different characters however they should
have a string of letters and numbers which are the same.

For example sheet 1 column A cell 1 may have ABC010456A and in sheet 2
column A ot may be CDA#010456A

I would want the find function to find what they have in common and
then copy the value for the same row but column i

Please someone help.....trying to compare over a 1500 rows is very
very very time consuming.

It's much appreciated.

Thanks

Stuart- Hide quoted text -

- Show quoted text -

Hi there

Thanks for the response.

I can place the data on the same column. It's not normally the case
but to get a solution to this then I will move the column.

The string will be more than 4 characters and I don't think it will be
more than 7.

I look forward to hearing from you,

Stuart- Hide quoted text -

- Show quoted text -

Hi

To explain some more.......

I was hoping you could use the search function to search for the
string in a cell from one sheet and search for this string in another
sheet. The data in both sheets is not the same at all except for
these partial strings hence I thought the search/find function could
be used and if the string is found when excel looks down the rows then
copy to cope the cell on the same row from column i.

Please let me know if this exaplin more to you,

Thanks

Stuart