[mso] Re: XL Custom list
- From: David Good - ANSYS Europe <david.good@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Mon, 9 Sep 2002 06:17:16 -0400
You could also do this with formulas:
A1: 06/09/02 B1: =TEXT(A1,"dddd")
A2: =A1+1 B2: =TEXT(A2,"dddd")
A3: =A1+7 B3: =TEXT(A3,"dddd")
A4: =A3+1 B2: =TEXT(A4,"dddd")
Then just highlight A3:A4 and replicate down.
HTH,
Dave.
-----Original Message-----
From: Nikunj Shah [mailto:catchnikunj@xxxxxxxxx]
Sent: 09 September 2002 11:03
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: XL Custom list
Pete -
You will have to create two Custom Lists.
To create a custom list
1. <Tools>  <Options>  <Custom Lists>
2. Select NEW LIST
3. Enter 1st list as: Friday, Saturday
4. Click Add
5. Enter 2nd list as the Dates you want (you will have
to write down all dates in the list box or write them
down in a worksheet and wile creating custom List,
supply relevant range in the Text box "Import List
from Cells:"
6. Click OK.
7. Go to the cell where you want the 1st date and
enter the first date, press Enter
8. Got to that cell again, and move your mouse pointer
over it until you see a thin Plus sign.
9. As soon as you see the thin plus sign, left click
and drag it over the range where you want the list to
appear then release the mouse button. Now you
Automatically see the List :)
10. To enter days, repeat the same procedure.
11. In case of difficulty, come back to me, :- )
However, this is doing it almost manually. Maybe it
can be further automated by using a macro, I do not
know.
Regards
Nikunj
Mumbai, India
--- Pete Harrison <peterl.harrison@xxxxxxxxxxxx>
wrote:
> I want a fill down that does the following
>
> 6/9/2002 Friday
> 7/9/2002 Saturday
> 13/9/2002 Friday
> 14/9/2002 Saturday
>
> etc, etc When I try just doing the fill handle, I
> either get sequential
> dates or I get a copy of the dates. I want it to
> follow the sequence - any
> ideas?
>
> many thanks
> Pete
>
> London - UK
>
>
>
*************************************************************
> You are receiving this mail because you subscribed
> to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
>
> Or, visit the group's homepage and use the dropdown
> menu. This will also allow you to change your email
> settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing
> files with the group, send a request to mso-moderators@xxxxxxxxxxxxx
> and you will be sent an invitation with instructions. Once you are a
> member of the files group, you can go here to
> upload/download files:
> http://www.smartgroups.com/vault/msofiles
>
*************************************************************
__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files: http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
