Hello,

I have 2 different workbooks/worksheets with data about my clients. I want to know if those workbooks/worksheets have data about the same customer. How do I find it..?

I cant merge the worksheets/workbooks as the data apart from client name are different.

Thanks and regards... Fazil

Hi Fazil

Thanks for your question.

If you simply want to find something in particular in a spreadsheet you can use the Find feature. Ctrl + F will open the Find feature or you can go to Edit - Find.

Then type in what you are looking for and Excel will select the next instance of what you are looking for in the spreadsheet.

I hope this helps.

Amanda

Thanks Amanda..,

The spreadsheets I am talking about runs the data of thousands of customers and so it is difficult to compare each customer name using Ctrl + F. It is equally difficult to compare them by minimising to display side-by-side in the screen as, apart from 'customer name' other data in the spreadsheets are very different.

Is there a way to tell 'Excel' to run through both the spreadsheets, compare the data on 'Customer Name@ column and report back saying, 'this is the list of customers present in both the spread-sheets'

Thanks and regards,
Fazil

Hi Fazil

I think this would require VBA code to be written in order to produce the results that you are looking for.

Amanda