offset problems

[gerald.lebret]

Hello Everyone,

I'm working on an excel file and would really really need some help.

Here is my problem
I'm working on a file and I need to use an offset formula on a whole bunch of cell.

In fact, I'd like to be able to select a range of cell and when I apply the macro, excel would ask me how I want to offset all the cells included in my range.

The tricky part is that I want to offset the content of the cell and not its result

For example, I have a formula in F14 that refers to BC7 from another file.
In F40, I need to get the result of bc30 from the other file which means I need to offset the content of f14 by 23 lines.
In F66, I need to offset it by 46 lines
And so on.

In fact if I could get a macro which would ask me for example the reference cell/formula, the cell(s) I want to offset and how many lines it needs to offset. That would be perfect.

I don't know if it's possible but if someone could help me, that would be great.

(P.S: I also tried the indirect function, didn't work!!)

I don't know if it's possible but that would be very usefull.

Thanks in advance for the help.