2 pivot tables on one tab
Is it possible to put 2 Pivot tables on the same tab in my workbook?
Or does anyone have any ideas on what would be the best way to chart Capital
Pircahses? I have 5 coums and 4 rows. The rows are per division, and the
columns are for the disposal amount, gain or loss, book value, depreciation &
purchase price. I already have one pivot table in my report. Would this be
You can put multiple pivot tables onto a worksheet. If the second one is
based on the same data, select and copy the first, select a cell some
distance away, and paste it. Each pivot table...XmlSerializer/XmlTextWriter all data on one line
I'm an XML newb.
I'm serializing a class and when I inspect the xml file, all the data is on
one line rather than being nested and indented
Is that normal?
StreamWriter sw = new StreamWriter(m_optionsXmlFilePath, false);
XmlSerializer xmlSerializer = new XmlSerializer(typeof(Options));
XmlTextWriter xmlTextWriter = new XmlTextWriter(sw);
> I'm serializing a class and when I inspect the xml file, all the data is on
> one line rather than being nested and indented
> ...combine 2 vbs into one
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "c:\windows\system32\drivers\etc\POSTS", "c:\windows
Set fso = CreateObject("Scripting.FileSystemObject")
fso.MoveFile "c:\windows\system32\drivers\etc\HOSTS", "c:\windows
how do i combine this 2 vbs into 1?
"xmd" <firstname.lastname@example.org> wrote in message
...How to have one year value added to another cell
I have a cell where I date foramtted fill in the date.
How to have on another cell the date + one year automatically filled?
"AA Arens" <email@example.com> wrote in message
> I have a cell where I date foramtted fill in the date.
> How to have on another cell the date + one year automatically filled?
> A1 02-04-06
> B1 02-04-07
>...Sell at One Location, Deliver from Another Location
For a multi-store retailer, is there any way in RMS to sell a product at one
location, then deliver it from another one? For example, say a retailer has
two stores, which includes two Store Operations licenses (one at each store)
along with Headquarters. A sale is made at store 1, but the product is only
in stock at the store 2. Is there a way in RMS (with HQ) to sell the product
at store 1 but deliver it to the customer at store 2?
I realize that this can be done via a stock transfer (to move the product
from store 2 to store 1 after the fact), but this requires an additional
manua...How to know that character type in one cell of xls is more that s.
Q : How to know that character type in one cell of xls is more that s...
E.g How i will come to know that i typed more than specified charater, when
i am typing in that particular cell
Your character to test is in A1
In another cell enter =CODE(A1)>CODE("s"). You will get TRUE or FALSE
Or use =IF(CODE(A1)>CODE("s"),"Bigger","Not bigger")
Bernard V Liengme
remove caps from email
"Dharamendra" <Dharamendra @discussions.microsoft.com> wrote in message
news:C2427962-5283-43FD-B9B0-5B367EA2470A@microso...backup ISP with one exchange server
we have one exchange 2003 server and we use a External ISP T1
connection and the ISP DNS which has the MX record.
10 email.domain.org (First ISP IP address for the email server)
20 email2.domain.org (second ISP IP address for the email server)
We have a backup ISP connection that stays idle. when we switch over
to the backup ISP connection (because the first is down) we cannot get
the incoming email in. Outgoing works fine.
How can we get the incoming email to route to the one exchange server
with either ISP?
On 18 Jan 2007 18:06:16 -0800, "zakmanx" <firstname.lastname@example.org&g...Logging on to more than one HQ Database
we have several shops accross Europe where each country is using a separate
Database in RMS. To connect with the HQ I created a small batchfile that
the registry keys for the database the user has chosen into the registry and
then starts the HQ Manager. That works fine right now because we are using 1.0
where the reg-keys are always the same. In 1.3 (which we will be upgrading
things are a bit different. Here the Connection Details are encrypted and
are therefore from machine to machine.
That means I cannot include the registry-keys in the installation routine
be...ploting one cell from 10 worksheets into one chart
i am trying to figure out a way to plot one cell, lets say c-1 from 10
-30 worksheets, in one workbook; on one chart. Each worksheet is a date
and each c-1 value is just a number.
any help would help
Message posted from the Excel Tip Forum at http://www.ExcelTip.com/forum/
-- View and post usenet messages directly from http://www.ExcelTip.com
-- Hundreds of free MS Excel tips, tricks and solutions
You can plot each data point as a separate ser...transferring macros from one PC to Another
I have some macros on one PC. The machine is very slow and I want to
format it. But I want to transfer all my macros to a CD or another PC.
Please help me in doing that. Tell me how can I do it.
Suman, to move to another computer you can export a macro and save it, to do
this from your workbook, right-click the workbook's icon and pick View Code.
This icon is to the left of the "File" menu this will open the VBA editor,
click on the module you want to save and go to file and export file, then
save it to a CD or what ever you backup to, then import it to the...How does one make VS compile unsafe code
This is not the first time I've used unsafe code in C# projects.
Usually, I simply check the box in the project properties telling it
to allow unsafe code. I've done that for this project, yet VS is
telling that, "Unsafe code may only appear in compiling with /
unsafe." So, here's the command line being used to compile:
C:\WINDOWS\Microsoft.NET\Framework\v3.5\Csc.exe /noconfig /unsafe- /
nowarn:618,1701,1702 /nostdlib+ /platform:x86 /errorreport:prompt /
I'm betting that this is complaining because the switch that appears
above is "...Newbie Help for Custom Number Formats
I am working on a spreadsheet that I would like to have it append the
inch symbol as part of the number format ("). I figured out that I can
add custom suffixes with the use of the quotation marks, but I can't
place a quotation mark inside of quotes and get what I need. Is there
any way to have Excel do this for me?
I know it seems like a small thing to do, but having Excel add this for
me would save me a lot of time with formulas and all.
Thanks in advance.
j...One Million FR.EE Visitors
How To Get 1 Million Visitors On Your Web Site
Without Paying A Dime In advertising !
Are you frustrated by the lack of traffic coming to your site?
If I would tell you that after months of research, I just got my
hands on the most hidden secrets... very sneaky tricks !
Click here : http://www.freeadguru.com/cgi-bin/i.pl?c=a&i=27202
Hurry, before the page gets banned!
MAF Anti-Spam ID: 20050420235059T4s5XoH1
...How do you print one address label at a time on avery 5160 labels.
I'll bet you have partial sheets of labels. I know that's why I have to use
a work-around. You'll have to use a template of the entire sheet, not the
1. Go to http://publishermvps.com/Default.aspx?tabid=38
2. Download the template for Avery 5160 labels.
3. Create the label you want.
4. Print said label.
5. Thank Brian for saving you A LOT of time and work.
(I've been known to lay my label out in Publisher and then copy and paste it
into a Word document.)
MVP Microsoft [Publisher]
"sharonm" <email@example.com&...Maximum but one less
How to identify second to last (in maximum) data
WIth data like this, with repeating Order Numbers (for example):
Area Code Order Open Date
Is there any way to retrieve the 2nd to last order details? I know about
maximum and minimum, but basically I want maximum - 1.
That is return
Order Number Order Open Date
Any assistance would be appreciated.
You can use a subquery within a query to do this:
S...Returning one of two values in Microsoft Excel 2003
I am trying to allocate values across various headings in my worksheet.
In, say, A2, data is input via drop down box. Depending on the value of
this entry, and on entering a value in B2, B2's value is allocated to a cell
under a general heading via the formula =IF(OR(A2="value1", A2="value2",
A2="value3"), B2, " ") This is an income allocation spreadsheet.
My problem comes in my outgoings. Once again data is input via drop down
box and depending on these values I have to allocate my outgoings whether the
currency value is input in cell B2 o...Divide one row over other row I dont wont to divide one number ov.
I need to divide one row over other row, is there any help i dont wont to
divide one value over other but i need function to do for the complete row or
...How to freeze one column vertically, one horizontal in same sprdsh
Is it possible to freeze a column vertically and one horizontally in the same
Do you mean other than Row 1 and Column 1? If that is what you meant, then
the answer is "no".
Rick (MVP - Excel)
"sweaver" <firstname.lastname@example.org> wrote in message
> Is it possible to freeze a column vertically and one horizontally in the
What cell is below the row you want frozen and to the right of the column you
want frozen. Find that inter...Two things for a newbie!
Firstly hello to all, I'm sure this will be an easy one but I haven'
used Excel in years so i know it can be done but can't for the life o
me remember how to do it.
Ok so Ive got a standard spreadsheet and I want to perform an I
statement followed by THEN (I think thats right) on a column of cells
For arguments sake lets say i want it to run on the first 100 cells i
column F. I want it to check the value of the cells and change th
backcolour of the cell dependent on the outcome. If the value in th
cell is equal to 0 i would like it to turn red, if its greater than 0
would like it...One query to multiple databases
I have five different databasesd that I access through five different odbc
connections. They bases are identical, but the data in them are not. Several
times, every day, I run the same query on each of them, and then I combine
all the results I get from each base.
Is there anyway that I can do this automatically?
Use a UNION query.
Build a little, test a little.
> I have five different databasesd that I access through five different odbc
> connections. They bases are identical, but the data in them are...eConnect newbie
I'm sending SOP invoices from a web store to Great Plains Dynamics 7.0
via eConnect 7.0 (eConnect_API class eConnect_EntryPoint method). I'm
calling the eConnect assembly from a C# web service that will receive
the incoming SOP transactions as XML. I'm only supplying XML schemas
for the invoice header and detail lines of each transaction. That all
The issue I have is with SOPNUMBE. It should be, in my case at least,
an incrementing number. There is a table in Great Plains, SOP40200,
that contains a record with the last SOPNUMBE used. However, I wish
to avoid touc...linking multiple charts from one xcl workbook
I have a ppt presentation that uses six different charts that I created in an
excel workbook. I want the charts in the ppt to update every time I enter
data into the excel worksheet but when I use the link function
"insert->object" it ends up putting the same chart on all the ppt slides
rather than the one slide it needs to be on. Any help is appreciated.
Insert Object From File inserts the active sheet at the time the file was
last saved, or the active sheet at the time the object was inserted, if it
is active in Excel at that time.
I would recommend that you copy the cha...How can I copy ONE contact folder to another PC?
I am using OL 2007 on both PC's. On my laptop I have a subfolder in my
"Contacts" folder I would like to copy to my desktop PC. Is there an easy
way to do this?
Posted to Outlook groups daily:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After furious head scratching, <----- Mardman -----> asked:
| I am using OL 2007 on both PC's. On my laptop I have a subfolder in
| my "Contacts" folder I would like to copy to my desktop PC. I...What formula can one use to Count dates?
Here's the Question:
I want to know what I will get paid TODAY, THISWEEK(Monday-Friday) or by the
I know how to get what I will get paid today:
In cell C2 =IF(A2=TODAY(),B2,).
I don't know how to get the Week (D2) and Month.(E2)
A B C D E F
1 Dates Amount Today This This
2 6/27/06 $500 0 $700 $700
3 6/28/06 $200 $200 $700 $700
4 7/1/06 $600 0 0 $700
__________________________...Transfering data from one spreadsheet to another.
I have a spreadsheet that is created by a program I use at work. I run this
report weekly and there are hundreds of loads each week. The spreadsheet has
the info I need but not in the right format. I need to know if there is a
way to pull this info into another spreadsheet in the format I am looking for
without a bunch of copying and pasteing. He is an example of what the report
Load# Destination Charge Desc. Charges
12345 Columbus, OH Fuel $100