Macro for changing an absolue refrence value within an formula (Row, Columne)?

Hello,

Im new to this forum, infact this is my first post.

If anyone knows a way to create a macro for changing an absolue refrence value within an formula (Row, Columne)?

This is how the formula looks;

=AVERAGE(IF(Runs!$BH$4:$BH$50000>0;Runs!$BH$4:$BH$50000))

I want to be able to copy / past this formula where ever i need and then do a short comand for updating the formula with:

Row + 2
Column +1

The macro cant be specific, i want the same macro to work on this formula aswell;

=STDEV(IF(Runs!$DL$4:$DL$50000>0;Runs!$DL$4:$DL$50000))

Ive been looking all over for a asolution to this, is it even possible?

Thanks in advance! :-)

Thanks for answering,

I’m sorry but at the moment I don’t have a sample worksheet, due to that I don’t know if I will be able to solve this (with help)

Basically I will have a worksheet contain lots of raw data, it will be stored column wise, I estimate the data to go up to column "DCR" and be about 15000 rows long.

In another worksheet I will try to look at this data with median, average and so forth, in this worksheet I will have about 200 unique formulas with in an area of rows, all set to look in specific places in the raw data sheet.

Now, I want to copy all these 200 formulas, paste them 8 columns to the right, since I made all the formulas with absolute references (to make sure no one accidently move something) they will stay the same as before my copy / paste action but 8 columns to the right. Now, the newly pasted set of formulas (200) need to look 1 column to the right from the original ones and 2 rows down.

I don’t know if this helps, but since I copy and paste 8 columns / 0 rows and want the formulas to look 1 column and 2 rows down I don’t know how to solve it, I need to do this a roughly 100 times.

Thanks