Jan 13 2021 08:57 AM
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.
Jan 13 2021 09:07 AM
@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).
Jan 13 2021 09:19 AM
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 |
Jan 13 2021 09:32 AM
Jan 13 2021 09:42 AM
Perfect, sh1 A1:J1 = sh2 A1:J1 where sh1 is manually input.
Jan 13 2021 09:53 AM
@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.
Jan 14 2021 06:52 AM
@MikeP1978 I got it figured out, thank you guys for trying. The formula I was looking for was =('sheet#'!cell#) will import info from one cell on one sheet to another.
Jan 14 2021 06:57 AM
@MikeP1978 , okay, thanks for the update. Just in case, if that range is needed only for Chart it's not necessary to copy it into Sheet2, you may take data within Chart directly form Sheet1
Jan 14 2021 07:01 AM
@Sergei Baklan That is good to know, I'm not sure that it will be good for my current needs but definitely will work on it today to get a better understanding. Thank you.