Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2017, 06:30 AM
custhasno custhasno is offline Random series inserted midtable when drag copying Windows 7 32bit Random series inserted midtable when drag copying Office 2010 32bit
Novice
Random series inserted midtable when drag copying
 
Join Date: Mar 2017
Posts: 4
custhasno is on a distinguished road
Default Random series inserted midtable when drag copying

Hi folks, first time poster so please forgive any noob mistakes.

I am trying to create my teams rota for the next year. I have it setup so that each week the staff move down one row on the rota until they complete the full cycle and go back to week 1 so the first week in the rota has everyone name in order. Every other week has a formula pulling the name in the row above the previous weeks rota.

I have it all setup so i can drag and copy out a two week block and it has all my dates perfect, however it has randomly started adding series to some of the times in the rota, i say random buts its always the same cells on each week and i cant figure out why. I've tried formatting all of the cells in the rota table the same way, first to hh:mm then to text but still the same issue on the same cells when i drag copy the rota to create a block for every week in a year.

Screen shots of what I'm doing and the random series it creates mid rota:


http://imgur.com/a/3mFia

Here is a copy of the rota:
https://www.dropbox.com/s/3cycm17ias...Rota.xlsx?dl=0

https://www.scribd.com/document/342440265/Test-Rota
Reply With Quote
Reply

Tags
copy and paste, series

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying diagram from excel to power point or word changes name of series in the diagram DrNic Excel 0 02-18-2016 09:08 AM
Random series inserted midtable when drag copying Series numbering ericjowens Excel 2 09-03-2015 11:20 AM
Random series inserted midtable when drag copying Fill Series alamorchgirl Excel 1 08-15-2011 10:05 AM
Data Series Zach Excel 1 11-05-2010 02:45 PM
Error Copying file or folder - Drag-N-Drop--> Network Shared Kris.Fulgham Outlook 1 10-17-2005 09:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft