Forum Discussion
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.
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 |
Perfect, sh1 A1:J1 = sh2 A1:J1 where sh1 is manually input.
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.
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
