I have a worksheet that is calculating off of another sheet but I
right now have to manually change which column they reference because
it is not in order (A,B,C) but rather (A,C,E) and its not just that,
the data jumps around so it might go, A,B,C,D IE,IF,IG,IH so I
cannot have it automatically adjust when I drag the formulas. However
for each calculation formula that title is referenced from the correct
column, so for example the first cell will be =Convert3!a1 then
=Convert3!IE1

I would like to find some way whether its a macro or a formula to
enable me to better setup the calculations. So in the calculation
instead of looking at the title and having to manually enter a1, IE1,
ect just take that formula read the data below it such as A2, IE2, ect
and use that cell to do the calculation. The formula for the
calculation is btw

=(COUNTIF(Convert3!A$2:Convert3!A$2000,4))/COUNTIF(Convert3!A
$2:Convert3!A$2000,"0")


Sorry I know it is confusing but if anyone could help it would be very
helpful, also even if I could find away to just paste the title's
formula that could help a bit so when I manually change them I can see
what the formula is.

Thanks and ask away if you need more info.

One way:

=(COUNTIF(OFFSET(Convert3!$A$2, 0, MATCH("Title", Convert3!$1:$1) - 1,
1999, 1), 4)) / COUNTIF(OFFSET(Convert3!$A$2, 0, MATCH("Title",
Convert3!$1:$1) - 1, 1999, 1), "0")

In article om,
"tnederlof" wrote:

I have a worksheet that is calculating off of another sheet but I
right now have to manually change which column they reference because
it is not in order (A,B,C) but rather (A,C,E) and its not just that,
the data jumps around so it might go, A,B,C,D IE,IF,IG,IH so I
cannot have it automatically adjust when I drag the formulas. However
for each calculation formula that title is referenced from the correct
column, so for example the first cell will be =Convert3!a1 then
=Convert3!IE1

I would like to find some way whether its a macro or a formula to
enable me to better setup the calculations. So in the calculation
instead of looking at the title and having to manually enter a1, IE1,
ect just take that formula read the data below it such as A2, IE2, ect
and use that cell to do the calculation. The formula for the
calculation is btw

=(COUNTIF(Convert3!A$2:Convert3!A$2000,4))/COUNTIF(Convert3!A
$2:Convert3!A$2000,"0")


Sorry I know it is confusing but if anyone could help it would be very
helpful, also even if I could find away to just paste the title's
formula that could help a bit so when I manually change them I can see
what the formula is.

Thanks and ask away if you need more info.