Ian has attended:
Excel Advanced course
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
RE: Copying Formulae
Hi Ian, thanks for the post, I have been trying to recreate your problem, however having a little bit of a difficulty in getting an example together of the problems you are experiencing, could you please give a little bit more info, I'm almost there with an answer using an exercise of my own, but as I say, need a bit more info. (P.S. I tried using Custom Views, and it nearly worked.)