Excel copy from one cell to another
Posted on 2011-09-03
I have the following formula:
=INT((INDEX('Evaluation - Level 2'!$G$5:$G$69,1,1))*100)&"%"
It works as expected. However, I need that same formula to work with 50 cells. Example, the next cell will be:
=INT((INDEX('Evaluation - Level 2'!$H$5:$H$69,1,1))*100)&"%"
The only aspect that changed is that the G became an H.
I do not want to copy/paste/update each cell. I would like to add a column with the values G, H, I, J, etc and pull from that column to update the formula. Please advise. Also, if there is an easier way please suggest.