Hello sir/madam
I want to link two excel sheets in same workbook.
I means that in one sheet I entered customer name and in another sheet entered customer's address.
I want when I click on customer name then their address is shown to me...
Is this possible...
Help me..
Thanks

Why do you want to do this? What you are talking about are database functions. Excel is a database so that by naming the fields into which you enter data you can relate to these fields. The idea of a spreadsheet is that you assemble relevant data so that you can access it and manipulate it and by linking it to Word use it in mailing and other functions. Having more than one sheet in a workbook allows you summarise or keep related data together. Research macro functions that may give you the functionality you want for this exercise