[mso] Re: Excel Macro Question
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 3 May 2005 20:35:25 +0200
Christine,
I'm realy curious wether you got any further on your problem.
Lisa
> Hi Christine,
>
> The below code is Q&D but should do what you want.
>
> It assumes the office name is in A1. If it isn't then you
> will have to
> alter that and the bit that does the sort.
> You should be in the sheet you want to split up when you run it. It
> will create a sheet for any office that doesn't have one.
>
> The bit that goes to the last cell in A1 to paste the data
> on the end
> is really ugly. Can anyone help tidy that up please?
>
> HTH
> Lisa
*************************************************************
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 with the word "unsubscribe" (without the quotes) in
the subject line.
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:
