Results 1 to 7 of 7

Data not dragging down properly

Threaded View

eeps24 Data not dragging down... 09-30-2016, 12:31 PM
Norie Re: Data not dragging down... 09-30-2016, 12:38 PM
eeps24 Re: Data not dragging down... 09-30-2016, 12:43 PM
JeteMc Re: Data not dragging down... 10-01-2016, 11:46 AM
eeps24 Re: Data not dragging down... 10-03-2016, 12:39 PM
Jonmo1 Re: Data not dragging down... 10-03-2016, 12:58 PM
FDibbins Re: Data not dragging down... 10-03-2016, 02:46 PM
  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    192

    Question Data not dragging down properly

    I am trying to drag column D down so it keeps following the pattern.

    Here is the order
    worked
    not worked
    weekday or weekend (depending on column C) formula based on column C
    Bradley
    Day
    Evenings
    Nights
    total

    When I try to drag from D26, it pulls down but then gets weird and doesn't follow my order. Anyone know why? I want to fix this because I will do more than october and many more months. I'd hate to have to copy my list paste it one at a time for each day.

    data sheet attached. thank you
    Capture.PNG


    *you can ignore the vba icon.. i deleted that sheet. I had it to update all my pivot tables in 1 shot.
    Attached Files Attached Files
    Last edited by eeps24; 09-30-2016 at 12:43 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] An array formula (VLOOKUP) isn't dragging down properly
    By GIS2013 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-05-2019, 10:31 AM
  2. [SOLVED] Dragging SUMPRODUCT formulas downward is not working properly
    By InterstateRentals in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-11-2014, 07:09 PM
  3. Skipping Every 5th Row and Dragging Down To Get New Data
    By seannydj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2012, 10:00 PM
  4. data dragging
    By jaydeep in forum Excel General
    Replies: 1
    Last Post: 01-20-2012, 02:03 PM
  5. shift patterns / dragging data
    By oopspete in forum Excel General
    Replies: 3
    Last Post: 11-19-2011, 02:26 PM
  6. Dragging data from one spreadsheet to another
    By lukela85 in forum Excel General
    Replies: 1
    Last Post: 07-03-2010, 06:32 PM
  7. Odd behaviour in dragging data across and up and down cells
    By Isaac The Arian in forum Excel General
    Replies: 0
    Last Post: 07-03-2006, 09:40 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