excel training program - copying formulae

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Copying Formulae

excel training program - Copying Formulae

resolvedResolved · Low Priority · Version Standard

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

Edited on Tue 1 May 2007, 16:56

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.)


 

Excel tip:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips


Server loaded in 0.09 secs.