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.
Bookmarks