+ Reply to Thread
Results 1 to 3 of 3

Creating a formula by using data in another file

  1. #1
    Mindy
    Guest

    Creating a formula by using data in another file

    I have four files for each quarter of the year. I want to add the number
    from the first quarter of speadsheets into the next quarter. How do I add
    that cell to my formula?

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523
    with the file open just do what you normally do when you refernce cells
    just go
    =and then go to the workbook with the cell you want to reference
    now they are linked

  3. #3
    Duke Carey
    Guest

    RE: Creating a formula by using data in another file

    Open both files. In the file where you want the number to appear, in the
    CELL where you want it to appear, type an = sign, then use the Window menu to
    activate the other file. Navigate to the cell with the value you want and
    press the Enter button

    "Mindy" wrote:

    > I have four files for each quarter of the year. I want to add the number
    > from the first quarter of speadsheets into the next quarter. How do I add
    > that cell to my formula?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1