Skip to content
  • Register
    • Advertisement
    If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
    Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
    Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
    If we do not hit our goal we will be forced to close the site.

    Current status: https://keepboardsalive.com/

    Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

    Linking Excel Data

    • 16-08-2010 05:19PM
      #1
      1durks
      Closed Accounts Posts: 4
      ✭


      Hi, would appreciate if anyone can help with this.

      I'm trying to create a summary file that will update automatically from source files in excel, ie. I have numerous monthly data entry files that are seperate workbooks (and not worksheets) whose totals are updated within the same file, I want to link the totals of each of these files to a seperate file.

      Can anyone explain how to do this?

      Thanks.
      Tagged:


    Comments

    • #2
      TiGeR KiNgS
      Registered Users, Registered Users 2 Posts: 1,435 TiGeR KiNgS
      ✭✭✭


      IF I understand you right

      copy the cell(s) that you want to link
      open the new workbook and paste special (paste link)

      This will stay up to date.


    • #3
      1durks
      Closed Accounts Posts: 4 1durks
      ✭


      Thanks, that worked perfectly, exactly what I needed to know! Cheers.


    Welcome!

    It looks like you're new here. Sign in or register to get started.
    Sign In
    Register
    Advertisement