Ask Experts Questions for FREE Help !
    rohit kumar001's Avatar
    rohit kumar001 Posts: 1, Reputation: 1
    New Member

    Feb 19, 2016, 01:23 AM
    How to link two sheets in same work book...
    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..
    paraclete's Avatar
    paraclete Posts: 2,704, Reputation: 171
    Ultra Member

    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

Not your question? Ask your question View similar questions


Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.

Check out some similar questions!

Link two excel sheets [ 1 Answers ]

Hello I want to link two excel sheets, so that when ever I update, delete or add any anything or any row or column in first sheet, that will automatically update the same in second one also

How to link multiple excel sheets to one main source excel sheet [ 7 Answers ]

I have a master price list and multiple ( individule ) sheets for customers.. I would like to , when input data in the price list to link and update to all other sheets... ( I do not want to have a source sheet with tabs) Thanks

Making a link between two cells in two different sheets [ 5 Answers ]

How to link a cell to another cell in two different sheets? Making a link between two cells in two different sheets

Link of excel sheets [ 1 Answers ]

Link excel speadsheet

View more questions Search