Closed Thread
Results 1 to 2 of 2

Autofill Reference down column

  1. 12-14-2013, 04:51 AM #1
    marcimarc
    marcimarc is offline
    Registered User
    Join Date
    08-24-2010
    Location
    London, England
    MS-Off Ver
    Office 2007
    Posts
    8

    Autofill Reference down column

    Hi there!

    I would be grateful if someone could help me with the following problem.

    In B4 I have =Diary!B3
    In B5 I have=Diary!B53

    How can I drage down and autofill the B column so that B6 will show Diary!B103, etc.

    Many thanks in advance for your help.
    Reply With QuoteRegister To Reply
  2. 12-14-2013, 05:06 AM #2
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Autofill Reference down column

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

    http://www.excelforum.com/excel-gene...wn-column.html
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill formula down rows, but increment column reference
    By rchudgar in forum Excel General
    Replies: 17
    Last Post: 06-12-2018, 11:55 PM
  2. Autofill formula down rows, but increment column reference
    By ahs004 in forum Excel General
    Replies: 1
    Last Post: 07-01-2013, 12:14 PM
  3. [SOLVED] Autofill Upwards With Reference to Adjacent Column
    By picton2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2013, 04:12 PM
  4. Autofill Formula in Macro that acts as "live" autofill, not absolute reference
    By BW78 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-17-2012, 08:24 AM
  5. reference autofill.
    By mtnone in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2006, 03:50 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1