Sort order for chart only and not on spreadsheet
Hi there! I neet to plot a simple graph with the data below
The relevent numbers (are actually scores) keep getting updated for each
candidate. I want my graph to plot it in the order of highest score to
lowest (whilst keeping my spreadsheet in the same order A,B,C,D . . .)
every time I update the score (automatically) without me having to change it
everytime I do it.
I have 32 entries. Can I use a macro to do this
Can anyone pls help me plssssssssssss
Thanks so mu...Trial Version of CRM 12-23-03
I am trying to get a trial version of CRM, does anyone know where I can get
it? We are a Microsoft Certified Partner but have not received any info
about it yet.
...Is there any way a macro can be created for various print area selections?
I'm looking to see if anyone knows of a way to have a macro select a
print area of a constant width (columns A thru K) but with a variable
length. Our MRP system will dump our BOM's into Excel and all of the
BOM's vary in the number of rows used. Some can be 3 pages while
others will be 15 pages. Currently we have to set up a print area to
capture the information we want printed under columns A thru K
everytime we go to print a BOM.
If you hit ctrl-end, do you go way past where you think the data should end?
If yes, you could use the techniques at...How can I update endnote cross-references in Word 2007 ?
I created a long document with many endnotes and some cross-references to
these endnotes. When I insert a new endnote somewhere in the document, the
following endnote numbers change but not the cross-reference numbers. This
seems to be a bug in Word 2007 as it worked perfectly in my previous Word
version. How can I update endnote cross-references in Word 2007 ?
Ctrl+A, F9 should work in all versions of Word.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Joe56" <Joe56@discussions.microsoft.com> wro...Solution for: Windows XP (NL): Windows Activation Problem + Windows Automatic Update Problem = Very Slow Computer.
I think I have found a solution on the internet, I will sum it up
shortly because the description wasn't that accurate, my description
will be more accurate with additional information about what I think
might have happened, but first a little story what I wanted to do
Today I wanted to try and install Service Pack 3 for Windows XP dutch
This was not possible because Windows Automatic Updates was required
by the Microsoft website to be able to download it and windows
automatic updates is malfunctioning, so that became a short attempt.
Then I decided to ...KB982524-.Net update
WIN XP PRO SP3
I have just dll, burnt to disc and installed this update.
All went well - the yellow shield has gone from system tray, but on checking
Add/Remove, the KB installed is 976576??
Is this correct?
On 2010-06-25 8:43 a.m., antioch wrote:
> WIN XP PRO SP3
> I have just dll, burnt to disc and installed this update.
> All went well - the yellow shield has gone from system tray, but on
> checking Add/Remove, the KB installed is 976576??
> Is this correct?
KB982524 says that 982524 is an update rollup, and references 9765...Old business card that will not print to Avery s8371 template
I have an old business card designed previously in Publisher. I can not print
to an Avery S8371 template in Publisher 2007. How do I correct this problem?
The printing does not correspond to the pref. lines in the template.
Use one of the pre-formatted Avery templates. They are all the same... 2.5 x 3.
Open your old file, copy/paste into the new.
Mary Sauer MSFT MVP
"Jeff B" <Jeff B@discussions.microsoft.com> wrote in message
>...Please Help: compare values in two columns present in seperate tab
How can I compare values in two columns (columns are in different tables) ?
I also want to display the values that dont match in a seperate table.
If values in Column1 from Table1 does not match Values in Column1 from
Table2 then display those values in a seperate table
Is there a way to do this?
THanks in advance
Under query types, there is one for unmatched data and one for matched.
State of Arkansas
> Hi All,
> How can I compare values in two columns (columns are in differe...How do I convert an excel spreadsheet into a pdf?
You need a pdf creator program to do that, there's a free one called
PDFCreator at sourceforge.net
Or you can buy one from Adobe.com
Try this site
"pphelp" <email@example.com> wrote in message
I also recommend the method used on this site.
Will make one PDF file from multiple sheets.
Gord Dibben Excel MVP
On Fri, 7 Jan 2005 23:45:29 -0000, "William" <firstname.lastname@example.org> wrote:...Comparing two columns of text data
I'm working with copies of someone else's SAP files.
Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".
After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.
Notifications have distinct numbers, as do work orders.
So you may have:
NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to thr...old topic, new questions: VSS and Exchange
I saw in a post on VSS and Exchange in a microsoft newsgroup and I had
a quick question.
Is there a site (or can you answer) that describes the disadvantages
and advantages of using the Exchange VSS Writer vs. using the streaming
API? I'm having a hard time picturing scenarios and what I understand
so far is that VSS doesn't allow "no loss" restores or "out of place"
restores. But what these are is blurry to me. Given that the Recovery
Storage Group was touted as an awesome feature for Exchange 2003, is it
thus useless if you are using VSS as your backup strategy?...Import old messages from slaved hard drive
Outlook Express won't import my old folders & messages
from drive 'E' now I'm on new computer with 'C'.
The closest I came to accessing got me a message to close
OE, but then I can't import.
Any advice greatly appreciated
see tomsterdam.com for help in setting up OE using our old files.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, Visual Quick Start Guide - OneNote 2003
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/exp...update /delete external refs
I have written a macro and want to se it on older
workbooks.This requires that a new page replaces an
existing page.However all the references come over with
the new page.I want to use edit/find replace all to replace
[JUL02]Frame!C$6 with Frame!C$6 ie delete all references
to original worksheet.(or some other way!)
I have figured it out!.I copy the new page over to the old
worksheet and then change source of links back to itself!
>I have written a macro and want to se it on older
>workbooks.This requires that a new page replaces an
>existing pa...is there a way to make graphic indicators of status
In MS Project you can customize a field to give a graphic indicator for the
status. Is there a way to do it in excel?
You appear to want Conditional Formatting.
You may find the following helpful.
Go into F 1 Help Facility and type in:-
Hit the Search, "button".
There is s topic called:-
Conditionally formatted data: Examples and guidlines
Click on the above topic.
Opening the above topic there is a hyperlink about three quarters of the way
down the page called:-
Conditional Formatting Samples
Click on...Is there any way of calculating a running total within a single cell in a column
Can anyone help with this query?
e.g. I want to work out how many people are working at any time in a
24 hour period. The number of people rostered on differs each day of
Monday Time No. rostered on
(and so on)
Can I add additional staff number in my 'no. rostered on column' by
just entering the number into the cell.
Say, if there were an extra 2 staff starting their 8 hour shift at 9.
am. is there a way of just typing in '2' into that cell and getting
What I do at the moment ...Update pass through query of report recordsource
I am working on upsizing my access backend database to SQL Server. I have
linked all sql tables to the frontend and am now running into the issue of
slow performance on one of the reports.
One way to improve that I thought was to change the recordsource query
(which is a saved query) to a pass through query. However there are form
controls that drive the parameters. So I was wondering if a better way to
do this is to create the sql query string in vba and then set the report
record source. Is this a viable option? Is there a better way?
Please ask any leading questions i...Track Changes compatibility between versions of Excel
I'm planning to undertake a project which involves Excel sheets
created in Excel 2003 and tracking the changes made to those sheets
via Excel 97. Does anybody know of any problems with the compatibility
of this function? This would help me out a lot. Thanks.
...Access2000: Update query
I have a table p.e. MyTable with columns ID, F01, F02, ..., F12
I also have a view/query p.e. MyQuery, also with columns ID, F01, F02, ...,
where MyQuery.ID is read from MyTable (i.e. both table and query have same
set of ID-values), and rest of fields are calculated based on data from
other tables in database.
Now I need to update MyTable with values for columns F01 - F12 from MyQuery
for all ID's. Somehow I don't get it working. What will be right syntax?
Thanks in advance!
Normally, you use something like
UPDATE MyTable INNER ...Security Update for Windows Server 2003 (KB956744) Cannot Install.
For Windows Server 2003.
This is a standard Windows Update that I try to install but get a message
that it failed to install. I can't find any source to tell me why it won't or
what I can do about it. I am not getting an error code of any sort - it is
just listed under "not installed" when I get my update installation screen at
the end of the installs.
Can anyone help please?
I downloaded the update manually from:
Ran it, and then ran Check U...Is there a way to change preset margins?
I have figured out how to change the default template, which is great. Is
there a way to change the margin presets in Word 2007? I don't want to
change the default/normal template - I use several types of page marins
routinely, but only a couple of them are in the presets. However, I NEVER
use the 2003 Default margin with 1.25" side margins. Is there a way to
create my own presets to those that I use regularly?
No way to create presets, but you can certainly create templates with the
desired margins; see
http://word.mvps.org/FAQs/Customization/CreateATemp...Outlook 2003 Update Fails
Using automatic update I have downloaded and tried to install an update
listed as Outlook 2003 Junk Mail Filter (KB925254), but every time I get a
message that the update failed. I tried to go to the Microsoft website to
find out about this but do not know where to go or who to tell.
Apparently this was in my outbox and I did not realize it. Please disregard
to see my related message.
"flyer" <email@example.com> wrote in message
> Using automatic update I have downloaded and tried to install an update
> lis...Upgrade Publisher 2000 to version 6.0
I'm running Version 5.0 and can't open documents created in 6.0.
Please i need a way around this stuff quickly. I
deal with large excel
files and usually have to comapare an electronic
copy (current) and a
hard copy (downloaded from a server a week earlier)
and make some
remarks on the new one.
I could actually lay my hands on the electronic copy
of the older
list. The prob now is that how do i automate the
process and let the
program (excel or any other u might suggest) note
the missing rows
(numbers) in the newer and give a PASS remark on the
I have tried all the tricks i know about writing/
macros and vba to no avail. P...Exchange version
How do I find out what version of exchange I am running. WE have small business server 2000 with exchange running on it. I went into exchange manager and clicked on help about and it comes up with microsoft management console with no reference to exchange.
If you're running SBS2000, you're using Exchange 2000.
> How do I find out what version of exchange I am running. WE have
> small business server 2000 with exchange running on it. I went into
> exchange manager and clicked on help about and it comes up with
> microsoft management console with n...Whats the latest version on GP
Great Plains 8.0 - GP 8.0 extensions is now available. The latest
service pack for GP is SP2
Visit MBS Blog Central
"Jitu" <firstname.lastname@example.org> wrote in message
Latest Version of GP is GP8.0
"Jitu" <email@example.com> wrote in message