excel training program - Copying Formulae

Hi,


"Copying formulae when referenced cells in range aren't adjacent"


I am trying to drag a formula across a row of adjacent cells however the cells that are referenced in the formula aren't adjacent - there are some hidden cells that are being included that I don't want to include. Example:

=('Sheet1!$L10-'Sheet2'!AB200)*$F$11

If I drag this formula across to the next cell I would get:

=('Sheet1!$L10-'Sheet2'!AC200)*$F$11

When in fact I want to skip 4 hidden columns in between columns AB and AG and return:

=('Sheet1!$L10-'Sheet2'!AG)*$F$11

Any suggestions? I'm not great with macros which I guess is one solution...

Thanks,

Ian