Hi All,
I have got two spreadsheets with various columns in them.
One column in both spreadsheets has cells which contains one or more words and numbers.
The first spread has about 160 rows and the second spreadsheet has quite a lot more.
What I would like if possible is, if one word and or number match in each column then align the rows with the cells with the match in, including adjacent cells.
Thank you
Andrew.
I have got two spreadsheets with various columns in them.
One column in both spreadsheets has cells which contains one or more words and numbers.
The first spread has about 160 rows and the second spreadsheet has quite a lot more.
What I would like if possible is, if one word and or number match in each column then align the rows with the cells with the match in, including adjacent cells.
Thank you
Andrew.