Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...How do I make excel hide columns when it says cannot move objects
I select columns and try to hide them. Excel says it cannot shift objects
off the sheet. I try goto objects and it says there are no objects on the
sheet. I cannot hide or resize the column widths of certain columns. I
cannot figure out why I can't get it to work and hide or resize the columns.
Does anyone have any idea how to fix the columns so I can hide/resize the
columns? It only does it on some of the columns, not all of them. I can't
find any objects to delete.
...How do I make multi column stacked graphs in Excel
See the links on Jon's page for Cluster Stacked charts.
Ed B wrote:
...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...how do i make a value entered be * 2
I want to make the value of the number I enter be * 2
example: if I put in 1 i want it to equal 2 in my sum in another column
can anyone help me
> I want to make the value of the number I enter be * 2
> example: if I put in 1 i want it to equal 2 in my sum in another
> can anyone help me
This is probably what you need. Enter this in, say, Cell B1
where A1 will contain any value that you want as your input.
BenjieLop's Profile: http://www.exce...retain items in the list control when application is close
how do i retain items in the list control so that even when i close the
application, the items would be availiable in the list control.
You can do this by either writing into a file or write to registry.
To add to what others have mentioned about writing to the registry (or a
file if you'd like) remember to keep the "string" not just the index in case
the things in the list change the next time you run the program. You can
serialize all of the settings in your program using this method.
"dspman" <email@example.com> wrot...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...how to make a chart to show the availiability
i want to make a chart for small hotel that will show me th
availiability of the rooms by entering the date in and the day out.
Thanks in advanc
Message posted from http://www.ExcelForum.com
How do you envision the chart working?
eg dates on the x axis, free rooms on the y
or, rooms on the x, axis availability on the y
also, are all rooms the same, or do you want to separate doubles
Message posted from http://www.ExcelForum.com
Thanks for your reply Nicky i found a solution at
Message posted from http://www.ExcelFor...VB application crashes after QueryCencelSelectionDelete
My developing environment:
MS Win 2000 sp4
Visio 2003 standard SP2
In VB, the code for the event is as follows:
Private Function vdcFlow_QueryCancelSelectionDelete(ByVal selection As
Visio.IVSelection) As Boolean
Dim RetVal As VbMsgBoxResult
If selection.Item(1).Type = visTypeGroup Then
RetVal = MsgBox("Are you sure you want to delete step " &
selection.Item(1).Name & "?", vbQuestion + vbOKCancel)
If RetVal = vbOK Then
'Proceed to delete the step from table Step
If Not DeleteStep(Val(selectio...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...re re re ????
...make A6 cards
Publishing to make a greeting card from an A5 sheet to fold in half, making
an A6 card. Cannot find any ways of doing it. I have publishing 2003, and
my printer is HP photosmart 2410. Please help, Christmas is almost here and
I am need of help quick.
>Publishing to make a greeting card from an A5 sheet to
fold in half, making
>an A6 card. Cannot find any ways of doing it. I have
publishing 2003, and
>my printer is HP photosmart 2410. Please help, Christmas
is almost here and
>I am need of help quick.
Open a blank document. C...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...Re:
...Make Excel upload files via FTP??
A few days ago I asked about creating files from a Excel worksheet
that can be shared online.
Someone suggested this VBA: http://www.meadinkent.co.uk/xladvhtml.htm
I've been trying this and it works.
Now I want to get Excel to run the VBA-code every time the file is
closed, AND (and now comes the tricky part), to upload the created
html-files to a FTP account.
Every time the file is closed the macro "make_htm" should run, and get
the files got created upload from the local folder, to a FTP account.
Is this possible??
...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...Re-enter payee information
I have been using MS Money to pay bills and frequent
annoyance is when I type in the payee, the selection list
never shows the payees. I type it in and have to re-
enter the account number and everything. Doesn't make
sense that i have to keep putting this in. Anyone know
what I am doing wrong? I've checked these boards and
found help with my passport problem but no entries on
Money has two kinds of Payees. Explicit--those on the explicit list that
shows in Accounts & Bills|Categories & Payees|Payees--and implicit--those
that are recorded somewhere in a tra...Re: Outlook locks up with a officelifeboathang
"Andy Lay" <firstname.lastname@example.org> wrote in message news:...
> Message-ID: <email@example.com>
> X-Mailer: http://www.umailcampaign.com, ip log:22.214.171.124
> Newsgroups: microsoft.public.outlook.general
> NNTP-Posting-Host: 22.bb.5446.static.theplanet.com 126.96.36.199
> Path: TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl!newspe.com
> Lines: 1
> Xref: TK2MSFTNGP01.phx.gbl microsoft.public.outlook.general:737044
> Hi Swinglower-
> I have luck as you do :) A Chief Exec machine with this very issue....Re: Share sub-folder in Inbox
I already grant the permission to right person and add secondary mailbox to
the exchange account, in his outlook folder list, he can see the shared
mailbox, but only mailbox not the sub-folder, if we share those sub-folders
individually, then we can view under shared mailbox, but this shouldn't be
the way. we want it sub-folder can be viewed and not be set one by one.
"Sue Mosher [MVP-Outlook]" <firstname.lastname@example.org> wrote in message
Either you haven't completed the process of granting permission...RE: Apply this critical update from M$
Content-Type: multipart/related; boundary="axyeonzy";
Content-Type: multipart/alternative; boundary="innmlsikefhcqjc"
this is the latest version of security update, the
"September 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to continue keep...Re: How to delay ToolTip display time in CListCtrl Control
"Smallfrogs" <email@example.com> д���ʼ� news:...
> "Ali R." <firstname.lastname@example.org> д���ʼ�
> > ((CListCtrl
> > or if you have variable for your list
> > m_MyList.GetToolTips()->SetDelayTime(TTDT_AUTOPOP,5000);
> > that will set how long it stays up after it is displayed.
> > Change TTDT_AUTOPOP with TTDT_INITIAL to change the...RE RE: XP Install
Thank you for the information.
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
Dilly Dally wrote:
> Thank you for the information.
Did you post a whole new conversation to 'reply' to one you started?
It certainly looks like it right now:
That is your original posting - as archived. As of right now (could be I
need to wait for it ...