Tiger: If Office 2004 now on own Apps volume, MUD on own Docs vol.: what moves from 10.3.8 to 10.4 boot volumes?
3 STRATEGY CONSIDERATIONS:
In anticipation of Tiger delivery on Apr. 29, I've moved Office 2004 from
the OS 10.3.8 volume's Applications folder to a new OS-free, non-Apple Apps
volume. I've moved the Microsoft User Data folder from Users/~/Documents
to a new OS-free Documents volume (and left in its place an alias with the
word "alias" nipped off.)
When Tiger arrives, it will be installed on an empty partition, rather than
use the Panther partition. I intend to maintain my OS 10.3.8 boot volume
just in case I have problems with Tiger not playing nice with my hardware...How to print one header over several columns of data
I want to print one title over a span of columns - what is the command?
Format>Cells>Aligment>Horizontal>Center across selection?
Gord Dibben MS Excel MVP
On Thu, 27 May 2010 14:19:00 -0700, column title print <column title
>I want to print one title over a span of columns - what is the command?
...How to count rows with changing data
I have an imported list on sheet2 and it is maybe 100 rows. Each day the
data is imported the dates change along with the type of record associated
with each date.
Say this week there are 25 rows with 11/13, 20 rows with 11/14 and 25 rows
with 11/15 and 30 rows with 11/16. Mixed in with this each of these dates
might have a different type of record (each type has 4 options.)
I need to be able to do the following:
1.) I need to count the number of occurrences for each date and not only
show the total count but also show the date that is counted as the label.
2.)count the...Moving between accounts
In outlook 03 I used to be able to click on file then either change email account or move between email accounts i.e I have 3 different accounts set up wtihin outlook and I can only see one - the default at present. I have had a look on the site etc and can't seem to find how to do this one easily with new outlook. can anyone please suggest how to do this? Thanks HEAPS.
Submitted using http://www.outlookforums.com
"Cath" <cathjamo[at]hotmail[dot]com> wrote in message
> In outlook 03 I used to be able to...Transferring orders to invoice slow
Hi, how long should/does it take to transfer an order to invoice? For us, it
seems to take about a minute per order and when posting a batch of 400+
orders it takes all day to finish. In addition, it takes up a lot of system
resource making GP run extremely slow for all other users.
Anyone else experience this issue in their environment? Where can I look
for to speed things up? TIA.
...How do I correctly sort a list of zip codes that has both 5-digit.
How do I correctly sort a list of zip codes that has both 5-digit zip codes
and nine-digit zip+4 codes?
Assume the zip codes populate cells A1:A100.
Use a helper column, say column B. In B1 enter the formula
and copy down to B100. Then sort A1:B100 by Column B and then Column A.
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote
in message news:B41E9C09-972F-443D-AF0A-64927EA797CB@microsoft.com...
> How do I correctly sort a list of zip codes that has both 5-digit zip
> and nine...sort #5
I know how to use the sort feature in excel XP and have a macro to sort data
but is there anyway I can sort the data using a button/hyperlink/cell on the
As an aside, does anyone know why I can't see the posts I make to the group
but I can see all the replies?
Just drag a button from the forms toolbar onto the worksheet and assign your
macro to it.
Don't know the answer to the second I am afraid.
(remove nothere from the email address if mailing direct)
"elwyn" <firstname.lastname@example.org> wrote in message
n...Returning value from a cell
Not sure why this happens, but if I use:
=INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
I get $V$12599, which is the cell I expect to see. If I add the
indirect, below, I get 0 and not the text that is in the cell $V$12599.
=INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
Thanks in advance,
Did you leave something out in your message? The two formulas you posted are
identical to my eyes -...formula does not recognize value
i have a workbook that calculates exp dates. When the date lands on a
saturday or sunday, I want it to bump out to the following monday.
How can I do this?
Message posted from http://www.ExcelForum.com/
Make your formula consider the WEEKDAY result of its own calculation and add
1 ot 2 according to that.
HTH. Best wishes Harald
"Vato Loco >" <<Vato.Loco.email@example.com> skrev i melding
> i have a workbook that calculates exp dates. When the date lands on a
> saturday or sunday, I want it to bump ...How do you match one column's numbers with the 2nd column?
How do you math one column's numbers with the 2nd column?
Like if you had:
... and you wanted it sorted like so
Any idea how to do that?
lnsykalski's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3403
View this thread: http://www.excelforum.com/showthread.php?threadid=53792
Assuming your data are in columns A and B
insert a staging column before column B, with following formu...addition with a maximum value #2
Nevermind. Figured it out!
djarcadian's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1587
View this thread: http://www.excelforum.com/showthread.php?threadid=31496
...Variables and .value
Heres a simple script I've knocked together, largely by trial an error
$IPadd = ([System.Net.Dns]::GetHostAddresses($_) |select $_.ToString)
"Formatted with Write-Host:"
write-host $(" Username:",$usr.value) -foregroundcolor DarkGreen
write-host $(" Computer:",$comp.value) -foregroundcolor red
write-host $(" IP Address:", $IPadd) -foregroundcolor gray
write-host $(" Domain:",$dom.value) -foregroundcolor DarkYellow
w...Conditional Formating based on other cell values??
Is there a way to apply formatting to one cell based on the conditions of
another cell? For example, if A1 is equal to 10 then format C1 to red text.
Is there any way to do that. Please let me know either way.
There are instructions here:
With your example, select cell C1, and in the conditional formatting
dialog box, use the formula:
Dan B wrote:
> Is there a way to apply formatting to one cell based on the conditions of
> another cell? For example, if A1 is equal to 10 then format C1 to red text.
--...Pivot table add one column
How can I add one column in pivot table? When I added a column of Average 100,
pivot table created 3 more columns for the first 3 columns( and I don't like
Book Label Price Average
A Hard paper 200 100
B Soft 100 100
C Hard paper 200 100
F Plastic 50 100
K Soft 100 100
L Plastic 50 100
M Hard paper 200 100
K soft 100 100
R Soft 100 100
T Plastic 50 100
My pivot ...show items with no data option in pivot tables
Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????
I'm using Excel 2000.
Debra Dalgleish has some techniques at:
In fact, she has an addin that you may like:
> Can anyone help with some bizarre results I'm experiencing with the show
> items with no values check box in the field setting...How do I move Outlook 2002 to a new computer
Hello. I installed Outlook 2002 on a laptop about 5 months ago. The Outlook
came with my Ipaq and they recommend it for Activesync. It had to be
BUT, that laptop had problems and I bought a new laptop. I want to put the
Outlook 2002 on the new machine, move over my outlook email and other files
(both machines have XP and I believe there is a tool to migrate files over)
and register it on the new machine and remove it from the old. When I put
it on the new machine, I am told there are 50 uses left and it counts down.
How do I register it?
info ((at) kramd...Displaying a cell's value versus it's formula
I have created an amortization schedule. When you click on
a cell the toolbar shows the formula I used instead of the
dollar value. I don't want anyone to know the formula I
used so I want only the value show in the cell. I know you
can click on a cell and F2 and then F9 to calculate the
value, but I don't want to do that to calculate each
individual cell. Is there a faster way to do the whole
schedule at once? Thank you, Kris
If you lock your cell, and protect the workbook, you can hide the formulas and
just see the results.
Select your range to lock
Format|cells|Protect...updating CRM Connector when moving the CRM Database to another server.
What updates to the MS CRM Connector do I need to do if I'm moving the
CRM database to another server.
I have not been able to find any information on this :-(
Thanks in advance for any help,
...ListView header columns
I have a silly question, in a list view in report mode with column headers
enabled I am supporting sorting the items in the list view and would like to
show the silly little up and down arrows indicating ascending or decending
but I don't see any property related to having them displayed. Are they a
custom drawn item or am I just missing the obvious?
Ron Hall wrote:
>I have a silly question, in a list view in report mode with column headers
>enabled I am supporting sorting the items in the list view and would like to
>show the silly little up and down arrows indicati...Calculation Order problem. #2
sry about the bump, but i'm desperate for a solution to this.
ICE9's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=13565
View this thread: http://www.excelforum.com/showthread.php?threadid=265139
Operating System: Mac OS X 10.5 (Leopard)
I am working on a translation. <br>
I created parallel columns as per: <br><br>I am cutting and pasting my earlier work into this format. However, my footnotes are not moving over. I tried to insert footnotes in this new version, but that option was not available in the text box. <br><br>How do I get footnotes or endnotes for the text in the text boxes?
You can have either text boxes or footnotes.
Footnotes cannot exist in text boxes because text boxes are not part of the
text, they're graphi...Need 2 rows to display X axis data points for a line graph
X axis is 100 data points, and all must be displayed. They do display, but
are all mushed up. In Corel, you have the option to display the X axis on up
to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to
manipulate the number of categories between tick marks and tick mark labels,
but can't stagger data onto multiple rows. Any ideas or add-ins I could try?
Excel 2002. Thanks, Susan
This web page gives a suggestion for staggering your labels:
Jon Peltier, Microsoft Excel MVP
Peltier Technic...VBA and researching data thru 20.000 records
I have 2 sheets with several fields.
on sheet1, i have new data and on sheet2 i have old data.
i would like to update 2 fields of sheet1 with data from sheet2.
for that i want to compare 3 fields, let's say C, D, E.
if C, D, E are equal on sheet1 and sheet2, so i want to copy data from
fields A and B (from sheet2) to fields A and B of sheet1.
for now i use selection.autofilter .....
on the 3 fields to compare, but with my 20,000 records, it's really slow
(on 3.1 Ghz CPU and 1 Ghz ram).
So i would like to know if exists another way how to do it and for sure
thanka ...Data validation 07-26-07
I am seeking to apply form level validation for two controls in the
before update event of my form. My code looks like this:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strMsg As String
' An error that is special cased.
Const conErrDoCmdCancelled = 2501
On Error GoTo Err_BeforeUpdate
If IsNull(Me.cboMedium) Then
Cancel = True
strMsg = strMsg & "Medium required." & vbCrLf
If IsNull(Me.cboSubject) Then
Cancel = True
strMsg = strMsg & "Subject required." & vbCrLf
If Can...Conditional formating, values.
I've been fighting an unfair battle against Excel these past few weeks when
it comes to conditional formating.
It's my personal budget it's all about. Months are horizontally, expenses
vertically. A Total-row displayes the current balance, where a positive
balance is written in white, and a negative balance in yellow. I've done
this using conditional formating, but I'd like my worksheet to turn the
yellow numbers to red, when my creditlimit is used up.
I hope someone here can help me construct the rule for to take effect - I
simply can't get the numbers to tu...