+ Reply to Thread
Results 1 to 2 of 2

Incrementation of File Titles Using Autofill

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Grand Rapids, MI
    MS-Off Ver
    Office16
    Posts
    1

    Incrementation of File Titles Using Autofill

    I am using VLOOKUP to populate a table in Excel. The formula is identical from row to row, except the file in which data is being referred to is changing by one character.

    For example, cell B1 says:
    =VLOOKUP($A$1,'N:\August\[08-05-2018.xlsx]Assembly Throughput'!$A$3:$O$64,B35,FALSE)

    Cell B2 says:
    =VLOOKUP($A$1,'N:\August\[08-06-2018.xlsx]Assembly Throughput'!$A$3:$O$64,B35,FALSE)

    I would like to autofill the rest of the rows so that cell B3 refers to the file "08-06-2018.xlsx", cell B4 refers to the file "08-07-2018.xlsx", etc, but I don't know how to automatically increment these numbers, considering they are the title of a file. Is this possible? If not, is there another way to populate this table without manually inputting the file names?

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Incrementation of File Titles Using Autofill

    Welcome to the forum.

    Without VBA, the only way I know to get an incrementing filename is to use Indirect, like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    The portion in red will increment as you drag down. Note the quotation marks " and the & symbols for concatenation.
    The problem with this solution is that it will only work for open workbooks. If a workbook is closed, you'll just get an error.
    If this is impractical, then you'll need VBA. Something like in this thread, perhaps: https://www.excelforum.com/excel-for...ba-add-in.html
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Incrémentation
    By DWMOH in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-30-2017, 10:22 AM
  2. SI function incrementation
    By seyf1981 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2017, 12:49 PM
  3. [SOLVED] Filter//paste data to 2 columns (title & details), autofill titles to match details
    By Frankximus3 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-18-2016, 03:10 AM
  4. cell incrementation
    By everythingneon in forum Excel General
    Replies: 2
    Last Post: 07-01-2011, 11:00 AM
  5. Help with incrementation
    By s.walsh87 in forum Excel General
    Replies: 2
    Last Post: 07-15-2010, 04:01 AM
  6. Scroller Incrementation
    By unique in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2005, 06:25 PM
  7. Row incrementation not working.
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1