« previous next »
Pages: [1]   Go Down

Author Topic: Excel spreadsheet help  (Read 339 times)

0 Members and 1 Guest are viewing this topic.

Online Always THE HERD

Excel spreadsheet help
« on: January 22, 2011, 12:03:52 PM »
  • [Like]0
  • [Dislike]0
    • I have two spreadsheets. I want to data that I enter in one spreadsheet to also be entered in the other one. I know this can be done....but I forgot how to do it. I know using the = is somehow involved....but I forgot.

    Any help you provide would be much appreciated.
    Thanks
    Logged
     

    HerdFans.com

    Excel spreadsheet help
    « on: January 22, 2011, 12:03:52 PM »

    Offline Johnnyherd2

    • Junior Varsity
    • ***
    • Posts: 570
    Re: Excel spreadsheet help
    « Reply #1 on: January 22, 2011, 01:42:23 PM »
  • [Like]0
  • [Dislike]0
    • I think as long as both sheets are in the same book.  You can just copy the value of the cell you want (via right click) and paste it in the cell on the other sheet.  If that doesn't work you might have to right click and paste special and choose value or formula.
    Logged
     

    Offline luvherd

    Re: Excel spreadsheet help
    « Reply #2 on: January 22, 2011, 01:45:33 PM »
  • [Like]0
  • [Dislike]0
    • The easiest method is to have one file  with multiple  "sheets". The A sheet can reference data in the B sheet and C sheet, etc. We do it all the time. Macros can be programmed also but that isn't the easiest method for a layman.   
    Logged
    MU Alum
    Big Green Member


     

    Offline Carolina_Thor

    Re: Excel spreadsheet help
    « Reply #3 on: January 25, 2011, 05:16:45 PM »
  • [Like]0
  • [Dislike]0
    • when you paste, try choosing "paste special" then "paste link"... perhaps that will point you in the right direction.
    Logged
     

    HerdFans.com

    Re: Excel spreadsheet help
    « Reply #3 on: January 25, 2011, 05:16:45 PM »
    Pages: [1]   Go Up
    « previous next »