Forum Discussion

MikeP1978's avatar
MikeP1978
Copper Contributor
Jan 13, 2021

New to Excel formulas

I need the proper formula for taking data from several cells on one sheet and moving them to a different sheet to be used on a chart, any help would be appreciated.

Formulas and Functions

8 Replies

  • MikeP1978's avatar
    MikeP1978
    Copper Contributor
    Jan 13, 2021

    MikeP1978 

    Unfortunately I cannot upload the work book, but

    12.5

    20.0

    30.0

    40.0

    50.0

    60.0

    70.0

    80.0

    90.0

    100.0

    If I wanted to take this data from sheet 1 (manually input) and transfer it to populate the data for this chart on sheet 2

     

    28.0

    34.0

    42.0

    52.0

    62.0

    74.0

    84.0

    93.0

    100.0

    115.0

     

     

     

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 13, 2021

      MikeP1978 , it's not necessary to upload your actual workbook, you may generate the sample one with data exactly as in your post and desired result. It's worth to mention on which version of Excel you are. Hope Riny_van_Eekelen make a correct guess, but with above chances to receive correct answer much higher. And faster.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 13, 2021

    MikeP1978 That's a very broad question. Formulae can't move data but you can link data in one sheet to another. Can you be a bit more specific and perhaps upload your workbook (replace any confidential information with something else).

Resources