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

excel training program - copying formulae

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

excel training program - Copying Formulae

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

 

Training courses

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.