Solved

# Excel copy from one cell to another

Posted on 2011-09-03
242 Views
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.
0
Question by:msukow

LVL 33

Accepted Solution

Norie earned 500 total points
ID: 36478007
Why are you using INDEX?

As far as I can see all it does is return the first value in the range, eg H5, G5 and so on.

If the formula is going on row 1 you could try this and copy down.

=INT((OFFSET('Evaluation - Level 2'!\$G\$5,0,ROW()-1))*100)&"%"

If it's not row 1 just change ROW()-1 to ROW()-X, where X is the row the first formula is going in.
0

Author Comment

ID: 36478030
Perfect - thanks for the clear explaination
0

## Featured Post

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…