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

    Jun 25, 2007, 03:43 AM
    How can I link one data worksheet to another worksheet . Basically I want a one sheet is my daily working sheet and another worksheet month base record please help what can I do for my daily base and month base record in single intery update and after that both sheet update
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jun 25, 2007, 06:56 AM
    Just type in =address (ex: =Sheet1:A1 in Sheet2:B1) in to reference a value in another address.
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!

Excel Worksheets [ 1 Answers ]

I have several worksheets in an Excel spreadsheet. Is there a way that I can print a list of the names of each of the worksheets in the spreadsheet?

Preparing worksheets and adjustments [ 1 Answers ]

I am so confused, I am trying to prepare a worksheet in financial accounting and I am lost.. I have completed all of it except one that is this... "The long term note payable (24,000) bears interest at 1% per month. The unadjusted Interest Expense account equals the amount paid for the first...

Worksheets within the same workbook [ 21 Answers ]

Hi, I have many worksheets within the same file, what I really want is to have either a (link / go to option) from sheet1 to other sheets without using hyperlink because I want to send to others. Example: if I click on Apple from Sheet 1, I will go to Sheet2 Sheet1 Sheet2 ...

Protected worksheets [ 3 Answers ]

When you protect a worksheet in excel but unprotect certain cells, why can't you change the format of the cells or insert comments?

View more questions Search