Say I have cell C1 with the formula =A1*50 and its value is 1000 when cell A1 is 20. How do I copy the value 1000 into cell E1 instead of the formula =A1*50 ? Thanks!!!
I am heading no where, would appreciate if anyone can help by showing me the step-by-step way to set up a dynamic range/graph. Pardon my shallow knowledge in EXCEL.
cchuat
Say I have a chart made out of a range of data of the last 50 days, how do I have the chart updated each time when a new day's data is added to the end of the existing range and in the process, the new chart will display only data from the 2nd to the 51st day while omitting the 1st day's, so...