Is it possible to group data together so that it stays together when I sort
it alphabetically? I'd like to make a list for example, Police, Fire and
Ambulance stations. In cell a1 would be Police followed in b1, b2, b3, etc
the names of the stations. Then in c1,c2,c3 etc the relevant telephone
numbers. Then in a 4 would be Fire, followed by b4, b5, b6 etc the names of
the fire stations and then their tel numbers in c4, c5, c6 etc.The same
applies to Ambulance. Then I'd like to sort col A and keep col b and col c
together under the proper emergency service
Hope you can underst...Make a formula
Is it possible with Excel 2000 to automatically
make a list of all the formulas you are using in
your spreadsheet to print them.
Steven E.'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26758
This subroutine makes a new sheet (Formulas in Sheen N) in which all
formulas are listed together with cell reference and value. Not mine-own but
I have lost the reference to the author but I thank h...Ranking/Sorting more than 3 row's
I have a spreadsheet with 742 rows (of company names).
I have 5 columns of criteria for the companies.
Each column is a different criteria about each company, and has a numerical
rank for each company. 1-~75 (some columns/criteria have no rank for a
I want to create an overall rank of the companies based on how they perform
across the 5 rows. I want the companies with the most 1's at the top and then
those with 1 & 2's and then those with 2 & 2's etc.
Is there a way to sort or rank this spreadsheet of companies?
I would do a sum of the inverses of each of...Numbers won't sort correctly.
I have a column of numbers that were imported from a web site and they won't
sort correctly. I have tried reformatting the cells as general numbers but
that doesn't change anything. I discovered that numbers below 100 have a
space or invisible data in front of the number. If I remove it, the number
then shifts to right alignment in the cell and will sort as a number. Is
there any way I can remove these spaces from all numbers at once instead of
going down the column row by row?
Type a 1 into a blank cell on your sheet. Copy the cell. Mark the range of
your data...Report Writer Dexterity Error
I get a "Dexterity Runtime has encountered a problem and must close" error
when I try to run one particular modified report. The error occurs when I
add a sort function in Report Writer. When I remove the sort, the report
runs - without error. I am on GP 9.0.
...Automatic printing with or without a workflow process can it be done?
I don't know if i'm asking this in the right place but here goes;
I'm an admin seting up Microsoft CRM 1.2 and I want to know if there
is any way that i print out some basic details on to a label printer
when I create a case, heres the senerio
we are an IT company and when small jobs come into the repair shop i
want to create the case in in Microsoft CRM 1.2 which will then in
turn automaticly print out the case no. along with customer name and
contact phone number in plain text to a printer, this label can then
be stuck to the PC being repaired also i want the work flo...excell sorting question
does anyone know how to do a sort for how close a list of numbers com
to a designated cell with a index number in that cell??
sort by being the same or the closest to "44"
results should be:
Message posted from http://www.ExcelForum.com
You can add a helper column...
In the column next to that one (assume A1:A5) enter
=ABS(44-A1) and drag down to fill the series.
Select both columns and choose Data -> Sort and sort
according to the helper column.
"twosix >" <<twosix...Automatic Underlining of Outgoing Emails
From the beginning, all my outgoing emails are automatically
being underlined. I turn the underlining off, and the
text appears to be not underlined, but when I send a test
document to myself, the document I get back is all
underlined text. I'm using Word 2003 as my e-mail editor.
In Word 2003 options-general-email options-personal..... i turned of
all underlining. Now the text still appears to be not underlined, but
the outgoing message is all underlind text.
When i turn off Word 2003 as my e-mail editor, the problem is solved
Please help me get rid of this annoying and unsightly ...Sorting by Text field of numbers
I am using Access 2003.
I have created a database to help me files by "Lot#'s". Our lot numbers for
one of our products is all over the place so I created the Lot # field as a
text field. Ex: 02-01-01, 10000272925, 10-06-02-04-06 and 1503011 A1-02.
Why does access put - 1000272925 before 10-06-02-03-05? Does this look right
My thinking is that "10" comes before "1000272925". What affect does the
"-" have in sorting the numbers. Would I be better off to put a space
instead of the "-"? Can anyone help me ...Preserving formulas when using sort function
If I have a two columns of data say, A and B and the are added together in
rows in Column C eg
A1 + B1 = C1
A2 + B2 = C2 etc
If I then move the contents of cell A1 and put it in say A23 the value of C1
does not change because the C1 become A23 + B1.
However, if I sort Column A then the value of C1 changes and the formula
appears to be wrong because it now takes the new value of cell A1
How can I make sure that when the sort takes place that wherever the value
in A1 ends up it is still added to B1 to create a value in C1?
Any help appreciated
Why aren't you moving th...Downloads to Quicken automatically going to Money
I have Money and Quicken loaded on my PC. When I attempt
to download to Quicken, it is automatically loaded to
Money. How can I stop this?
Install Quicken second. The last one installed takes control of the QIF
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://register.microsoft.com/mswish/suggestion.asp
or email email@example.com especially if it's a UK specific wish.
I do not respond to any unsolicited email regardin...automatically create chart upon selecting
I have a spreadsheet containing about 50 different
financial ratios for 2002 thru the current month. I want
to be able to click on the name of the ratio and have a
chart automatically generate using all historical data
thru the current month, thus including each month as it
is added. Does anyone have any suggestions?
On Wed, 29 Oct 2003 07:43:30 -0800, Jason <firstname.lastname@example.org> wrot=
> I have a spreadsheet containing about 50 different
> financial ratios for 2002 thru the current month. I want
> to be able to click on the name of the ratio and have a
> char...Sort numbers with text in ascending order
I am having a difficult time sorting the following list:
MY List How Excel Sorts I Need
2148-00 1472-00 171B-00
1480C-00 1480B-00 171C-00
1480B-00 1480C-00 1472-00
1472-00 171B-00 2148-00
171C-00 171C-00 1480B-00
171B-00 2148-00 1480C-00
I have tried formatting numbers as text and other options. I am at my
wits end now. Is this sort even possible? Please help.
Where is the logic to your sort please?
If you can identify that then a sort may be possible! ...Automatic printing
Is it possible to use a macro to print out a worksheet when a cell in
that worksheet contains a specified number? I have a worsheet that
pulls info from another program and I want it to print when cell d6 is
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Try the following:
Right click on the worksheet TAB>View Code
then enter the following code
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("d6"...Automatically add 1 until a number is found
I am developing a spreadsheet which basically grosses-up a paymen
which i have to make to an employee.
What I'd like to do is take a cell and add 1 automatically until th
number equals a specific equation. Is this feasible?
Message posted from http://www.ExcelForum.com
Have a look at Tools / Goal Seek. It might be what you are looking for.
"jkyndt >" <<email@example.com> wrote in message
> I am developing a spreadsheet which basically grosses-u...With start-up my printer automatically re-prints all work. Why?
I have a new OKI B63000 printer and every morning with Windows Start-Up, my
printer automatically re-prints all my day's work, needlessly wasting a lot
of paper and toner. I imagine there is a command somewhere for this. How can
I stop it?
Might look in scheduled tasks.
How To Schedule Tasks in Windows XP
Mary Sauer MSFT MVP
"Andry C" <Andry C@discussions.microsoft.com> wrote in message
news:D092C731-CE6D-403A-B7B3-6C3C57C2F92D@microsoft....Print Template automatically Filled with data in another worksheet
I have a Form in Sheet2 like:
Emp #: B5
and list of Employees A2:D123 (more than 100 employees) with above details
I want to Print Sheet2 for each of the employee with its details. I know It
easily done with Word Mail Merge option but the form created in Excel could
not be easily developed in MS Word.
Is there any solution.
You would need to use a macro:
Dim myCell As Range
For Each myCell In Worksheets("Sheet1").Range("A2:A123")
With Worksheets("Sheet2...macro to run automatically when a field is updated
I have two form fields on an employee appraisal form. One calculates a grand
average score from four different scoring areas on the form. The second field
evaluates this score (using a macro) to determine the increase percentage
based on the grand score. This macro is assigned to the field to run on
My problem is that if an evaluator goes back through the form and changes a
score, they must click in this percentage field to get it to update to the
My question is: how could I make this field update automatically anytime a
change is made anywhere on t...Updating form automatically
I have two columns in a table which are sources of dropdown boxes in a form.
In the form, when the value in one dropdown box is changed by the user, how
can I automatically update second dropdown box according to the data in the
table. For example in case of "copyone" as value in first dropdown box,
second drop down box has "paperone". When "copyone" is changed by "copytwo",
"paperone" should be changed with "papertwo". So far I am unable to do this
successfully either with SQL or VB. Any ideas will be highly a...Sorting data #3
I have my data organized in columns based on state standards, and I want to
regroup the data to get all Algebra questions together, all Geometry
Row 1: Question1 Question2 question 7 question 25
Row2: 6N1 7G8 5N15 6A9
Row 5-30 has student responses to the each question
where N, G and A represent Number sense, Geometry and Algebra. I want to
determine how the class did overall on each category.
I am pregnant with possibilities, and so are you!
Your question makes perfectly good sense to you because y...is there a way to automatically delete NDRs in the Queue
How can I automatically delete NDR messags in the queue?
"North Coast Sea Foods" <firstname.lastname@example.org> wrote in
> How can I automatically delete NDR messags in the queue?
I don't think you can delete them automatically, but you can stop them
being generated in the first place. In ESM, go to Global
Settings/Internet Message Formats/Default/Properties/Advanced . The
ones that are already queued will disappear in a few days' time.
Outlook Web ...Modifying the lookup window with VBA to sort by a column
How do I add VBA code so when I use the lookup button in Payroll Transaction
Entry that it will default to the Last Name Sort and start with the name
entered on the Payroll Transaction window in the Employee ID field.
You did not say which version, but if you are using the Advanced Lookup
windows, then you can set some defaults for these windows on Tools >>
Setup >> Company >> Advanced Lookups. Which will mean you don't need
VBA on this window.
(Available for outsourced projects)
-----Original Message---...Sorting Cells #3
I have a list that has 3 columns in it....a number column, a column for the
name, and then another colomn for where that file is. I am trying to list in
order of the first column (which is the number column) because that is how we
find the file. BUT, when I sort, the sorting doesnt sort right. I have 2000
numbers then 1990 numbers then more 2000 number when there shouldnt be. I
have checked all the formatting and everything seems to be the same. Can
someone help me on why this is doing this!!
Hi, Kirsten. It's so frustrating when Excel doesn't recognize our data
properly. See:...Forwarding email automatically
I have an employee leaving the company. Boss wants all her email forwarded
to another employee. Can I set this up in ESM or do I need to login into her
Outlook and setup a rule policy.
Go to user properties in AD Users & Computers | Exchange General | Delivery
Options and forward to the other user (under forwarding address -> forward
"AllenM" <email@example.com> wrote in message
>I ha...Password Issue
Don't get me wrong here, I have received plenty of great
information from MVP's and other regarding MS software,
but to make us all sound like idiots because we used the
suggested password system for a product is unacceptable.
MS specifically tells you it is highly recommended to use
Passport. Now while we all wait for the fix, we get to
listen to all of you tell us how stupid we are for even
using it in the first place. Personally, I can get
around using it for now, but it is rather annoying that
it is taking this long.
Funny thing, I had always used Quicken in the pas...