+ Reply to Thread
Results 1 to 4 of 4

Autofill

  1. #1
    Registered User
    Join Date
    05-23-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Autofill

    Hi all, I am trying to create a roster for my work that changes each night. We all rotate around and do different jobs during the night. So I would like to know how I can setup the autofill to fill in different cells that are not adjacent to the first cell.
    loadout roster.jpg

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Autofill

    Hi
    there appears to be a break in your pattern at truck 5. Is this intentional? Otherwise, the formulas in the attached will replicate the pattern for the first 4 rows.
    Attached Files Attached Files

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Autofill

    Paoroa welcome to the forum

    What is the logic behind this?
    Can you explain how you would do this manually?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    05-23-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    2

    Re: Autofill

    Thanks for the reply's. We have a different team of workers come in every day. As you can see in the roster, we rotate every truck so you are doing something different. Not stuck doing the one job all day. So I would like to just enter the initials of the workers on row 1 then have excel autofill the rest of the roster. Is this possible and how do I go about setting up autofill so this would work?

+ 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. Autofill base on Active Cell and Autofill by row count of another sheet
    By enyak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2014, 10:06 PM
  2. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  3. Replies: 0
    Last Post: 09-17-2012, 08:24 AM
  4. Macro for Autofill removes header info when there is no data to autofill
    By esturan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:42 PM
  5. Autofill problem or is it not autofill?
    By Pat Feasey in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-14-2011, 02:21 PM
  6. Replies: 1
    Last Post: 06-17-2005, 04:05 PM
  7. Replies: 0
    Last Post: 03-02-2005, 12:06 PM

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