Fazil has attended:
Excel Advanced course
Comparind data
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
RE: Comparind data
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
RE: Comparind data
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
RE: Comparind data
Hi Fazil
I think this would require VBA code to be written in order to produce the results that you are looking for.
Amanda
