Results 1 to 3 of 3

Using auto complete handle (+) with formulas

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2009
    Location
    Yorkshire, UK
    MS-Off Ver
    Excel 2002
    Posts
    2

    Using auto complete handle (+) with formulas

    Hi all - sorry I'm new to this so if i'm in the wrong forum, please forgive me...

    I have the following formula in a cell C6 : "='Data Dump'!G20"

    I want the adjacent cell on the right (C7) to be "='Data Dump'!G21" and C8 to be "='Data Dump'!G22" and on and on.

    I'm trying to use the Auto complete handle on the bottom right hand corner of the cell (which looks like a + when the cursor is over it) to drag the formula so that the "Data Dump - G" values increase as I go (g21, g22, g23 and onwards)

    However, rather than the numerical part of the cell incrementing, the character (letter) does so instead, so I get H20, I20, J20 and onwards.

    Can anyone tell me how to do what I want it to do?

    Any assistance would be very gratefully received
    Last edited by MattStan; 04-24-2009 at 11:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1