auto fill problem

J

Janebob

New Member
Joined
Oct 6, 2008
Messages
25
Have a work schedule--in column a, in cell a 4 have a day of the week listed and in the cell underneath --a5 have the corresponding date 2/22/11-----then have 10 blank cell in col. a then the next corresponding date and day i.e. day of the week and the corresponding consecutive date. Was then going and copying the first two sets of day and dates and then do a fill series. For some reason it worked the first time, but when I went to continue adding more days and dates- to extend the schedule for some reason It didn't work properly. Was getting repeats on the days and dates.For instance, instead of having just a day and date- i had a day and date, and a day and date repaeated occuppying 4 cells instead of just the 2 cells in column a. The day and date repeated was the same. Don't know what is causing the repeats.

Any help is appreciated. thanks
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
you have to fill the series using the blanks as well for instance

date
gap1
gap2
gap3
gap4
gap5
date
gap6
gap7
gap8
gap9
gap10
date

you need to start your fill area from gap1 to date after gap10 to set the dates equidistant
 
Upvote 0
Can you clarify this, the way i see this is:

Monday
28/02/2011
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
Tuesday
01/03/2011
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
[Blank Cell]
Wednesday
02/03/2011

You have to select the 10 blank cells whilst using the autofill

Regards
 
Upvote 0
Thanks for your help. I went and copied part of your replied and put it into a blank excel worksheet. This is what happened when I pasted it.<TABLE style="WIDTH: 62pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=83 x:str><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 62pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17 width=83>Tuesday

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=17 align=right x:num="40546">1/3/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>Wednesday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=17 align=right x:num="40577">2/3/2011

</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" id=td_post_2627981 class=xl65 height=17>Wednesday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=17 align=right x:num="40547">1/4/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>Thursday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=17 align=right x:num="40578">2/4/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>Thursday</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=17 align=right x:num="40548">1/5/2011</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl65 height=17>[Blank Cell]</TD></TR></TBODY></TABLE>

You have the right idea of what I'm trying to do but it still doesn't seem to work. Also, if successful with this I won't be using the phrase-blank cell when I do the auto fill.
 
Upvote 0
Dryer14-thanks for your help--please see my comment to Devon Knows--can't figure out where I'm going wrong with this. Had it working a few weeks ago--now no idea what I'm doing wrong.
 
Upvote 0
Hi,

I have done tested this to end of March and no Errors like what you are reporting, for a start the gaps between
<table width="83" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" class="xl65" height="17">[Blank Cell]</td></tr><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" class="xl65" height="17">Wednesday</td></tr><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" class="xl66" align="right" height="17">2/3/2011

</td></tr><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" id="td_post_2627981" class="xl65" height="17">Wednesday</td></tr><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" class="xl66" align="right" height="17">1/4/2011</td></tr><tr style="height: 12.75pt;" height="17"><td style="border: medium none rgb(240, 240, 240); background-color: transparent; height: 12.75pt;" class="xl65" height="17">[Blank Cell]</td></tr></tbody></table>

is not 10 cells so Excel will not be able to find the distinct pattern.

Monday
28/02/2011

Then Highlight the required number of cells (10 in the example) then drag down the AutoFill box to as far as you need, remember a ToolTip will come up every 11/12th box (2 cells of data and 10 blank cells) - This will show you what day and date you are up to.

Also, Just follow the above instructions and not copy and paste it from here to confirm correct result, copy and pasting is much to be desired between applications.

If you select it from the Day and highligh the date and 10 other cells i dont see how you are getting the above results, can you upload your test document.

Regards,
 
Upvote 0
Auto fill only auto fills what you are asking it to and upon that tries to identify a repeating and recognisable pattern, if your not select the correct cells or once you are using an auto fill, then adding to the autofill you must not be select the correct cells, do not copy all the cells, jus copy the last day and date entry plus 10 other cells and autofill down.

Tested on my pc and worked
 
Upvote 0
" jus copy the last day and date entry plus 10 other cells and autofill down"=======thank you thank you etc. What I was doing was copying the last two day and dates and the blank cells in between--- Not the blank cells and then the last day and date. Finally did as directed--copy the blank cells and then the last day and date--gosh thanks again.​
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Auto fill dates and days of the week from month
Replies
3
Views
250
awoohaw
awoohaw
A
  • Solved
Conditional Formatting for rows of empty cells corresponding with dates between
Replies
4
Views
468
avril18
A
J
  • Solved
Simple(?) issue with using =DATE and =SUM
Replies
1
Views
196
JackOfBlades
J
O
  • Question Question
Auto email code
Replies
3
Views
219
Logit
Logit
R
  • Question Question
Conditional formatting - number range to coincide with week commencing date
Replies
1
Views
377
awoohaw
awoohaw

Forum statistics

Threads
1,223,952
Messages
6,175,596
Members
452,658
Latest member
GStorm

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top