Pivot table, calculating % difference of subtotal rows
This is what I need to do: I have rows of data in a pivot table that
have subtotals associated with them (automatically generated via the
pivot table). I need to to take the subtotals for 2009 and 2010 and
calculate the % difference.
Here's a screenshot of what I'm talking about:
Is this even possible or am I going to have to do this manually?
Hi I have'nt seen the screenshot as am at work , go to Pivot
>This is what I need to do: I have rows of ...Identical Name on multiple workbook pages
As a hardened Excel/VBA nut, I'm probably going to be really embarrased when
I get the answer to this, but here goes...
I have a workbook containing a worksheet that records weekly data. I have a
named range ("Data") which I select then clear, via GoTo.
Each week, I copy the latest week's worksheet and create a new worksheet for
the new week. And each week, I select the range "Data" and clear it in the
most recently created worksheet.
the thing is, I always thought that Range names were unique across a
workbook, and that you couldn't have the same Range N...how do Ii remove the grey page numbers in a work sheet
how do Ii remove the grey page numbers in a work sheet
Try going to the View menu and unchecking Page Break Preview
On Wed, 2 Feb 2005 11:01:08 -0800, "parker1230"
>how do Ii remove the grey page numbers in a work sheet
You may be in page break preview mode.
Go to "View" and select "normal"
"parker1230" <email@example.com> wrote in message
> how do Ii remove the grey page numbers in a work she...How to change background color of a window that has been created.
I need to change the background of a window that has been created, can
> I need to change the background of a window that has been created, can
> you help?
Answer depends upon the type of window. Typically you can do this in OnEraseBkgnd.
Certain controls respond to WM_CTLCOLOR and yet some other, like CButton,
need to be owner drawn to change the color.
If you have a generic CWnd, you can always specify the brush in the window
class; so no special painting is needed. This is good when you know that
the background will have one color all the time.
-...Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different
tables that are created dynamically by a query. The data for these will
but I would like to simply pull the data from these tables to create a report.
The tables have the following information:
1. Company Info (name, address)
2. Customer Info (address, name, etc)
3. Customer Order (products, price, other info)
4. Invoice Info (ID, GST #, etc)
I realize I could have created a table with relationships but the data above
dynamic as there are 4 different companies and based upon user inp...Adding Values From Different Tabs
Is there a way to add values from different tabs on the same
For example A2 from tab 1 and A2 from tab 2
Flipkid2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17984
View this thread: http://www.excelforum.com/showthread.php?threadid=398184
Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use thi
note the name of the sheet is followed by "!" to indicate it is a shee
------------...Use Outlook Client when domain user name different with email acco
I have a question about using Outlook Client.
If the domain user login name is different with email account which belong
to a same person, is it possible to install / login with the Outlook client?
e.g domain user : degdom\apple
email account: firstname.lastname@example.org
One of my client is facing in this situation. I just want to have some
preparation before install Outlook Client for him.
Thanks for any help!
It shouldn't be a problem if the AD user is the same used to start
Outlook and connect to CRM.
You may want to check the email adress in CRM if the ema...creating a recurring reminder email message
I want to create a reminder message that gets emailed to a distribution list
on the same date every month. How can we do that?
...Margin Trouble with Custom Page Size
When I try to print in Publisher using a custom page size, printer or
Publisher adds approx 1.5" to the top of my page margin, no matter what I do.
Checked the printer settings in WordPad, all looks OK. Issue does not occur
when printing on 8.5X11 page, nor does it occur in MS Word. I don't have any
extra margin set in Master Page...have tried everything I can think of.
Under deadline to print invitations and getting desperate...help! Thanks.
How are you setting up your printer? Are you saving the custom setting? Are you
setting up your printer first? What model is your pr...connecting to data access page with filter criteria
I have an access database that I connect to from a GIS application (ArcView)
using VBscript. I need to port my GIS project to the free viewer (ArcReader)
which does not support VBscript but does support hyperlinking to a URL based
on a value supplied by an underlying record.
In my current project I can send filter critera to open a particular
database, form and record. Would it be possible to do the same using data
access pages or would I need to create a separate page for each record I want
...Excel page format changes
Operating System: Mac OS X 10.5 (Leopard)
Hello, <br><br>My client creates spreadsheets for her boss. She pushes the boundaries to get things to fit on the screen. <br>
Uses A4, margins at 1.5cms and scales to 90%. <br><br>When her boss receives it by email the margins go to 2.5cms, scales to 100%. They have the same versions 12.2.4 and Leopard. They are just about to be upgraded to Snow Leopard. Any idea why this could be happening? Thanks.
...Problem creating full text index
I seem to be unable to create a full text index of either my public or
private store. When I try to creat the index I get the error;
The directory name is invalid.
ID no: 8007010b
Exchange system Manager
This seems to be happening for both the public and private stores. The
directory does exist. I have looked over the permissions and tried to
compare to known working servers and I haven't moticed any obvious
differences. Any ideas?
Did you follow this article:
"Jonathan Huber" <JonathanHu...Cell identity when printing comments on separate page
Operating System: Mac OS X 10.5 (Leopard)
When printing comments at end of page, it identifies the cell by letters and numbers. (i.e. Cell: AA33) Afterward the comment is shown for that cell. <br><br>Question: Instead of the cell identity being shown this way, is it possible ithe cell can also be identified by its X axis header for that column with the y access header for that Row. <br><br>Thank for your assistance. <br><br>Carl
Sorry Carl, but I'm not clear on what you're asking for... In 'MySpeak' ...Money 2005 Bug: Portfolio toolbar button loads blank page titled Portfolio Manager
Problem Description: Clicking on the Portfolio toolbar button loads a
blank page that's titled Portfolio Manager. That's it! I can't see any
of my open positions, etc... using this toolbar button.
Frequency of problem: Always Happens
Operating system / version: Microsoft Windows XP Professional -
Computer manufacturer and model: Dell Computer Corporation, Dimension
Processor model and speed: I586IV, 1994 MHz
Memory (RAM): 523.276 MB
The only input I can offer is that I have the same problem on one computer,
but it works fine on the other. I converted from 2004 Delu...How do I create a spread sheet for tracking batting statistics?
Trying to keep a running log of batting stats for the season. Can anyone help?
> Trying to keep a running log of batting stats for the season. Can anyone help?
...Install 3.0 Failed
I am in the process of installing 3.0 on a server. All of the inital checks
are fine. I proceed to install and it fails with an error "Action
Microsoft.Crm.Setup.Server.CreateSetupUserAction failed HRESULT 0x80040237"
I searched the Knowledge Base and found KB 941498. I did what it said but
got the following error for msxml2.dll - LoadLibrary("msxml2.dll") failed.
The specified module could not be found. How do I go about getting XML 2
(the parser I'm guessing) when it hasn't be supported in years?
Is there something else I can do?
I am installing 3.0...Running macros for different cells at the same time
Is it possible to run different macros on different cells at the sam
time? If so how do I go about setting it up?
Message posted from http://www.ExcelForum.com
not really sure what you're trying to do. Could you give an example?
> Hi all,
> Is it possible to run different macros on different cells at the same
> time? If so how do I go about setting it up?
> Message posted from http://www.ExcelForum.com/
Yes it is possible to run different m...System Restore all off, still creating restore points on 2nd parti
Although we have System Restore turned off on all drives, restore points are
still being created on the secondary partitions.
The OS partiton is drive C, NTFS. The secondary partition is drive D, FAT32.
The restore points are being created when applications (i.e. DirectX,
WinDVD, etc.) are installed from the second partition (drive D). We must
install these from a secondary partition.
What are we missing? These restore points are filling up our drives.
Also, I thought System Restore wouldn't work on FAT32 drives?
Bill, I use two drives b...Create a new restore point
How does one create a new restore point in both Vista and Win7? When I go
to Accessories-->System Tools-->Restore all I get is how to restore from a
previous one. That's not what I want. I want to create a restore point.
On 3/9/2010 5:14 PM, OldManEd wrote:
> How does one create a new restore point in both Vista and Win7? When I
> go to Accessories-->System Tools-->Restore all I get is how to restore
> from a previous one. That's not what I want. I want to create a restore
Click "Computer" in start menu th...conditional formatting: separating rows with differing values
Need help with conditional fomatting.
What I need:
I got a worksheet with 950 rows and 5 columns. The first row contain
the headers. Columns A, B, D and E contains unique values. But the
column C contains text values which repeats sequentially for 6-7 rows
and changes thereafter. Now I want to put up a line (using border)
through the whole row dividing this transition row.
Compare C2 with C3, if equal do nothing. Then compare C3 with C4 and so
on till 2 consequtive values differ. Now divide the 2 rows using the
border formatting option in conditional formatting dialog box.
So...MC++ & C# generate different XML
I've been trying a long time now to generate some XML using MC++ and
XmlSerializer. I have a piece of C# code that produces exactly what I want,
but I simply can't get the MC++ code to write the same thing. Below I have
included two minimal compilable samples that illustrate my problem.
The C# code produces this XML:
<?xml version="1.0" encoding="utf-8"?>
<Units name="unit1" />
<Units name="un...Microsoft Word/Page orientation
In a multi-page document, is it possible to change
continuous pages from a page orientation of portrait to
landscape and back to portrait again? I have tried this
with page breaks inserted but it has not worked yet. I am
using Word 2000. Thank you.
you need to ask in microsoft.public.word or i could tell you the answer :-)
use section breaks
"KC" <email@example.com> wrote in message
> In a multi-page document, is it possible to change
> continuous pages from a page orientation of portrait to
> landscape and ba...dropdown filter on Data Access Page
I have a data access page that is based on a query in my database.
Currently the page brings up all data for today, and the page is formated
So it looks like this
Since this page can get long sometimes, I would like to add a dropdown menu
at the top of the page, that allows them to filter their results by team.
So once they make a selection they would only see the team selected.
Team (only 1 listed)
I've been trying to search on this, but jus...restore .ost file created in different exchange profile
Does anybody know how to restore email and other data from
an .ost file created by a different user in a different
domain name, please?
OST files are linked to the mailbox/profile for which they were created. If
you've got an orphaned one, you can't open it - you will need to google
OST2PST (an old utility that may still be floating around) and try to run it
against the file (make a backup copy first). Or see
www.exchangerecovery.com - I know it works, but it's $$$.
> Does anybody know how to restore email and other data from
> an .ost file created by a di...Text Function with Different Formatting for Number
I'm trying to use a text function where I reference a number from another
cell but I need the text part to be bold and the number not to be bold. This
is the formula I'm using right now:
Unfortunately, excel won't let me just make the text bold without making the
number bold. Anyone have any suggestions? Thanks
I think a macro could do this, since it's really a string you're going to
wind up with. But if you can put the Sales: part in a separate cell, life
will be much easier anyway. then you ...