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.
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
SergeiBaklan 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.
