PDA

View Full Version : How to link two sheets in same work book...


rohit kumar001
Feb 19, 2016, 01:23 AM
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

paraclete
Feb 19, 2016, 04:51 PM
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