Auto Sort #2
I was wandering if it is possible to sort a group automatically so tha
every time the data changes it automatically sorts by a certai
I want to auto sort a table (A2:H12) by column H is this possible ??
Message posted from http://www.ExcelForum.com
On the sheet that you want this to happen....
Right click on the sheet tab and select "View Code"
Then copy and paste the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("H2:H12")) Is Nothing Then
...System of linear equations
Greetings, can anyone tell me how to solve a system of linear equations in
Well, it would be good if you could provide more information. You can
use solver for finding optimum solutions. MMULT can solve linear
equations as an array.
> Greetings, can anyone tell me how to solve a system of linear equations
> in Excel? TIA
Can be done very easily with Solver or matrix functions.
Which are you more comfortable with?
Send example of a system of equations you want solved.
PS My book A Guide to MS Excel for Scientists an...Version conflict #2
I've created a file with Publisher XP on my office PC and tried to edit it
at home, whee I have Publisher 2000 (both have regular licence and are
registered). I'm getting a message saying "the version doesn't match, can't
open the file" (free translation from a non-English message).
I'm a bit surprised that 2K version can't read XP version - I never had a
similar problem with Word or Excel. It's me doing something wrong, or are
Publisher XP and 2K really incompatible? I'm a true beginner of publisher.
Both machines have Win2KPro, all pa...2 Exchange 2003 Server
I just installed the second Exchange 2003 Server (2 - 2 Exchange 2003) in
our Domain (everything is NATIVE MODE - AD/Exchange). For testing purposes,
I just migrated one account - a Support Account. When I open up Outlook
2003 SP2 client, I can receive mail and send mail; however, when I use OWA
using this account, it just goes to a Page can not be displayed -
Can someone tell me what I have to do to also get OWA woking here?
I have installed the IIS components required exactly the same on both
serv...bitmap problem #2
I am new to MFC programming can some body explain how to
use a bitmap (.BMP file) in a dialog box as a static control. I got
little piece of information from a broken link that,
The bitmap is defined in the .RC file as
BITMAP_NAME BITMAP DISCARDABLE "filename.bmp"
and used in dialog as
Can some body explain steps to add a BMP (to dialog box as static
to a MFC skeleton
Thanks in Advance,
Just attach bitmap hanbdle to Control Variable CStatic::SetBitmap()
You can d...search #2
I want to lookup a value in a sheet and when found give me the value
of the cell next to it. Vlookup will not work because the value looked
for is not necessarily in the same column. If I use
=VLOOKUP("beef",B:F,2,FALSE) it works great if the word beef is in
column B but if it is in A or C then I get N/A. Any other way of doing
The reason is that I am doing a copy paste from a web site and looking
for specific values.
In your search, you're returning the value in column C. What column do you
want to return if "beef" is in column A? And, what column do you wa...sent messages #2
all of my sent messages have disappeared
Check View | Current View and make sure it's set to "Sent To" or any other
unfilitered view. "Unread Messages" will hide anything marked as read.
Also make sure you're not sorting the message list by the Icon column.
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> all of my sent messages have disappeared
...why no email showing from 2/25/2010 or earlier?
Was out of the office from 2/25/2010 through 3/3/2010.
Email only goes back to 2/26/2010, and all email from 2/25/2010 or earlier
does not show. How do I find my incoming email from 2/25/2010 or earlier?
Perhaps you are only looking at UNread mail?
> Was out of the office from 2/25/2010 through 3/3/2010.
> Email only goes back to 2/26/2010, and all email from 2/25/2010 or earlier
> does not show. How do I find my incoming email from 2/25/2010 or earlier?
"Chris" <Chris@discussions.microsoft.com> wrote in message
news:0E...Need a time-date stamp for MS Outlook, please #2
From: "Hugo Acosta" <hacosta@CNYLatino.com>
Subject: Need a time-date stamp for MS Outlook, please
Date: Friday, September 22, 2006 11:34 AM
I apologize in advance if I am sending this request to the wrong place...
I would like to have a button in my MS Outlook 2000 toolbar, that when
clicked, it will place the DATE/TIME on (whatever) the cursor is located. I
work (volunteer) with a non-for-profit Church organization that has no money
to pay programmers, to develop (what I was told) this simple task;
therefore, I was advised to use this Internet avenue, and see if I could ...Offline Database #2
When configure de database offline . The Database Offline is backup to the
Database Primary or is better create a new Database from black.
create a new database from Blank.
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.
> When configure de database offline . The Database Offline is backup to the
> Database Primary or is better creat...Locking data #2
Is there any way that once a user has clicked a button or entered data into
a cell it is locked in an equivalent cell? For example
in Cell B1 formula =A1
in Cell A1 = 5
If the 5 becomes 6 then so will B1. But is there anyway, that by using a
formula or short onClick code I can make it so that B1 remains 5 even if A1
...Out of Office question #2
A company manager wants to set Out of Office messages for ALL users before
holidays in an international business. (Exchange 2000 environment).
He wants this because sometimes his workers are away or forget to set the
Out Of Office messages, and so overseas clients sometimes don't know why
they are not getting a reply.
Is that possible, to set one message for the entire company without doing it
Thanks for your thoughts.
> A company manager wants to set Out of Office messages for ALL users
> before holidays in an international business. (Exchange 2000
...Huge Av Disk Queue Length #2
We have a 2 cluster Exchange 2003 environment. Approx 150 mailboxes,
average 500MB, about 20 or so as large as 3GB. 4 storage groups, 4
mailbox stores per group, each store on it's own physical mirrored
disk, logs on seperate physical disks. Compaq servers, dual Xeon, 3GB
RAM, fast SCSI disks.
The problem we have is occasionaly Outlook will grind to a halt on
certain machines, particularly the PA's who have up to 10 shared
calenders open. I've set a performance monitor to check average disk
queue length on each of the disks. Most are fine and rarely go above
10 or so...canadian payroll errors when accessing employee setup #2
I've recently upgrading from Great Plains 7.5 to 8.0 and when i try
to access Payroll Employee Setup, i get the message "A get/change first
operation on table 'P_CPY_SETP_Employer_Number' failed accessing SQL
Data. When i click on the more info box i get
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
[Microsof...Worksheet Change Event #2
I saw a forum response a while back that will allow programming the
cursor to move to certain cells as the user enters data.
I cannot remember how that was done.
Can someone refresh my memory?
This time I will copy the information into my own little help file.
DCSwearingen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21506
View this thread: http://www.excelforum.com/showthread.php?threadid=474829
The code may have used the worksheet_change event.
Here's ...Obtaining More Relevant Templates #2
Does any one know where I can beg borrow or buy Publisher 2000 templates
that are more relevant to the UK.
Either you had asked this question about two weeks ago or you're asking the
same thing. What "more UK relevant" items are you looking for?
MVP Microsoft [Publisher]
"nebb" <nebb(erase)@freenet.co.uk> wrote in message
> Dear All
> Does any one know where I can beg borrow or buy Publisher 2000 templates
> that are more relevant to the UK.
> ...Your Only FOREX Online Trading Portal. #2
Thousands of affiliates cannot be wrong! The Forex (currency trading) industry is the world's biggest market on earth, with a daily turnover of 2.5 trillion dollars! Forex-Affiliate.com joins forces with Easy-ForexT Trading Platform, a world leader in online currency trading...
...Combo Box Resizes when clicked ... why? #2
In Excel 2000, activeX controls such as command buttons,
combo boxes, check boxes and option buttons will display
inaccurately until they receive focus. Fonts and symbols
used in the control often appear distorted until clicked.
For example, with the combobox, the dropdown arrow
appears scrunched. With command buttons it looks like the
height and width are both increased by 1 when clicked and
then the button returns to the wrong size when another
control receives the focus. This occurs on multiple
machines running Office XP, with and without service
packs 1 and 2 installed. The problem does no...How to MoveFirst, MoveNext, MovePrevious, MoveLast in LinQ To XMl Please Help #2
I have the Next XML
var xml = new XElement( "clients",
new XElement( "name", "Luis"),
new XElement( "country",
n...simple install instructions for CRM 1.2 installatio on SBS 2003
I have undertaken several attempts to run Microsoft CRM with the standard
intranet functionalitie of SBS 2003.
SBS 2003 with SP 1 and SQL SP4 is running well.
In spite of several instructions by chapter 15 or this
newsgroup will it not working. First some IIS and DNS errors and after that
a login error.
Is There someone who has an easy, clear and complete instruction guide?
In advance thanks for your response,
this address may help you
Göksal Ersen Çelebi
Senior Softwar...Customise Outlook Today #2
I'm running Outlook 2000 (as part of Office 2000 Professional) with SP-3
loaded and for some reason, the Customise Outlook Today button has ceased
working. The same thing has happened on two PCs loaded with two different
discs (I am sure it used to work but I can't remember if this was before or
after I downloaded & installed SP-3).
If I hover the cursor over the button, the button changes as if it can be
selected, however, when I click on it nothing happens!
Is anyone aware of how I might resolve this issue please?
OL2000: You Cannot Customize Outlook ...Act 6.0 #2
I have office 2000 and need to import my Act 6.0
database. My office does not have the service option
under Tools. Can anyone tell my how to import?
...OWA Logon page #2
I have 2 E2k3 installations and both have https enabled. However, on one
installation there is a pretty page that says OWA, public or private check
boxes, etc. But on the other when I log onto https://ex.comp.com/exchange
it only comes up with a dialog box and not the exchweb page. How can I fix
it to have the pretty page?
On Tue, 15 Mar 2005 19:04:35 GMT, "Bobby Janow" <firstname.lastname@example.org>
>I have 2 E2k3 installations and both have https enabled. However, on one
>installation there is a pretty page that says OWA, public or private check
>boxe...SMTP logging #2
Anyone know how to set logging on an smtp connector (on Exchange 2003) to
track sender, recipient, time/date, subject, destination server (ip or name).
I need to be able to go back and confirm that msgs were delivered (and to
what smtp server).
Check "enable logging" on the SMTP VS.
On Thu, 4 Nov 2004 15:06:01 -0800, Ivan92
>Anyone know how to set logging on an smtp connector (on Exchange 2003) to
>track sender, recipient, time/date, subject, destination server (ip or name).
>I need to be able to go back and co...Word Cells into Excel Cells #2
How does one import a cell formatted Word file *.doc into
cells within Excel *.xls.
By "cell formatted Word file", do you mean a table? I would simply select
table and click copy. Then open excel and paste it where you want it to
> How does one import a cell formatted Word file *.doc into
> cells within Excel *.xls.
> By "cell formatted Word file", do you mean a table? I would simpl
> table and click copy. Then open excel and paste it where you want i