offset problems

gerald.lebret

New Member
Joined
Nov 4, 2011
Messages
7
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.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,122,371
Messages
5,595,784
Members
414,020
Latest member
Meghdad

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top