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

    Sep 7, 2010, 10:06 PM
    How to link the whole sheet to another sheet
    How to link the entire excel sheet to another excel sheet
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Sep 8, 2010, 04:52 PM

    IN sheet2 cell A1 put this formula:

    =Sheet1!A1

    Now copy that cell down and across as far as you wish.

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!

How can I connect one sheet 1 in excel to sheet 2 so it will update the information. [ 7 Answers ]

What I am trying to do is I have a schedule with drop down boxes I want to beable to click on a name in the dropdown box next to a time slot for appointments which are listed under the days date like a calendar, but once clicked I need it to update the list on the first sheet next to the same name...

Link spread sheets sheet 1 to sheet 2 , 2 to sheet 3 [ 4 Answers ]

I have attach what I have done on the site. What I need to do is link all of the data from sheet one to sheet 2. All I have found so far is how to link one cell to the other cell. In sheet 1 I have af 3 to af 699 . I need to bring all that data to sheet 2 to (d3 to d24) Sheet 2 will link into...

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 [ 1 Answers ]

Connest two sheets like I have counts in sheet 1 and want total in sheet 2 .

Link masterlist from Sheet to Sheet [ 1 Answers ]

Is there a way to create a master list of names in one sheet so that when you add or delete rows or columns in the masterlist the other sheets that use this masterlist will automatically add or delete the changes? How would I copy this list. I tried to link it as a formula but that didn't...


View more questions Search