Copy Absolute References across Columns

**malawimick** · 01-06-2012, 08:56 PM

I have the following formula in Column E:- =IF(AND(Results!$E$7=Selections!G7,Results!$F$7>0,Results!$F$7<=5.99),Data!$M$2,0) and need to copy it from Column E through to Column P

In Column F "Results!$E$7" needs to change to "Results!$E$8" and "Selections!G7" needs to change to "Selections!J8" and so on....

In other words "Results" is incrementing by "1" and "Selections" by 2 alpha

The formula is 14 lines long on a 24" wide screen monitor meaning a lot of work to do it manually column by column (tests 40 different variables)

Is there an easier way to do this!

HELP! HELP! HELP!

Cheers

Malawimick

**Haseeb Avarakkan** · 01-06-2012, 10:09 PM

Try something like this,

Please Login or Register  to view this content.

Copy across.

**malawimick** · 01-06-2012, 10:20 PM

Hi Haseeb
Do you mean to copy this formula into columns F through to P - I tried this and it did not work - however that is probably my interpretation of what you mean and I am not real smart at this!!!!!!