Insert Blank Line and Sort------------liX6Lxsnq7Ovs6LAASpU5y
Content-Type: text/plain; charset=iso-8859-15; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Within a worksheet I have an example of data below consisting of four
columns.
I need to put a blank line in between the Racecourse (where they change)
and after do a sort on Rating (high to low).
Is it possible?
I could do it with a macro, but am unable to fathom out how to deal with a
differing number of horses at each racecourse.
Time Racecourse Horse Rating
04:30:00 SANDOWN Dare To Dance 0.261
04:30:00 SANDOWN Garud 0.153
04:30:00 SANDOWN Wes...
setting up tax tables in RMS
I have a client who has special tax needs.
$0-$1600 is taxed at 9.25
$1601-$3200 is taxed at 9.75
$3201- and above is taxed at 7%
so for example- for a $3,300.00 item- the tax would be $311.00. How would I
set this up in RMS?
Help!
Thanks
Andrea
Andrea,
Create 3 Sales Taxes.
Sales Tax 1
Minimum Taxable Amount = None
Maximum Taxable Amount = $1,600.99
Tax Rate = %9.25
Sales Tax 2
Minimum Taxable Amount = $1,601.00
Maximum Taxable Amount = $3,200.99
Tax Rate = %9.75
Sales Tax 3
Minimum Taxable Amount = $3,201.00
Maximum Taxable Amount = None
Tax Rate = %7
Assign all of these taxes to one...
Merge-Center iconOn some of my spreadsheets the "Merge-Center" icon is not active. The
simple spreadsheet instruction are of no help.
Is the sheet protected? If so, try Tools>Protection>Unprotect Sheet
"RoofinPA" wrote:
> On some of my spreadsheets the "Merge-Center" icon is not active. The
> simple spreadsheet instruction are of no help.
Hagen, I believe you are on to something. As you wrote I followed your
discussion, but when I clicked on "protection" a dialogue box opened with the
top three items dim "Protect Sheet","Allow us...
Filling Subdesc1 with Size on matrix itemsWhen I create a new Matrix Item and use a Dimension Set that we've previously
saved (shoe size is what we use as Dimension 1), is there a way to get the
Attribute value of Dimension 1 to automatically fill Subdescription 1?
Again, for us, the Attribute of Dimension 1 is shoe size - and we want
Subdescription 1 to be shoe size. If this can't happen automatically, is
there a script we can run to have Dimension 1 fill Subdescription 1?
Thanks,
--
Kris
Additional info:
We used to run the following script to get Subdescription 1 filled with the
size, but that was with 1.3, maybe ...
Setting up Conference Rooms as Resources in Exchange 2003Hello,
I've spent a considerable amount of time fishing around for a document I had
once found describing a Microsoft add-on to Exchange 2003 that would allow us
to set up conference rooms, projectors, etc., as resources to invite or
schedule in Outlook. Does anyone know where this went to? So far I can't
seem to find it.
Many thanks!
Auto-accept Agent Admin & Deployment Guide
http://www.microsoft.com/technet/prodtechnol/exchange/2003/library/autoaccpt.mspx
--
Bharat Suneja
MCSE, MCT
--------------------------------
"AJWS" <AJWS@discussions.microsoft.com>...
blank two fold 8 1/2 x 14 brochure templateswhere can I find a download for a tw 0r three fold blank 8 1/2 x 14 brochure
template
It is a simple page setup. Setup your printer for legal stock and then your page. In
the arrange menu select two or three columns.
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"kawika" <kawika@discussions.microsoft.com> wrote in message
news:E99D8D0A-E6C8-48A2-A5AF-C5B6E365219C@microsoft.com...
> where can I find a download for a tw 0r three fold blank 8 1/2 x 14 brochure
> template
...
Tabbed Pages Not RefreshingAccess 2007, with two tables. Table A has field1 as the primary key field
Table B has field1(same as field1 in table A) and field2 as a dual primary
key. The two table are joined via an inner join using field1 (1 to many)
A form has been created, towards the top is field1 plus other fields from
table A
The form has 5 pages below, with field2 on each page.
If I create a new row on the first page of the paged portion of the form,
and enter a value into field 2, it will not show up on the other pages unless
I navigate to the next record on the main portion of the form and then go
...
drag and fill optionsTotal novice here, so sorry if i annoy anyone, anyhow my work sheet
won't allow me to drag and fill my formula? Could do it the other day,
but just returns o's now. I have been to my tool bar but dont see any
options to correct anything. Any suggestions?
thanks mewmew
Do you see the little autofill box in the bottom right corner of the activecell?
If no, then I'd try:
Tools|Options|Edit Tab|Check Allow Drag and Drop
mewmew wrote:
>
> Total novice here, so sorry if i annoy anyone, anyhow my work sheet
> won't allow me to drag and fill my formula? Could do it the o...
i want to set conditional format to cells containing odd numbersi want to set conditional format to cells containing odd numbers
1. Select the cell/Range (say A1:A10). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=MOD(A1,2)
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK
PS: If you are using XL2007 Goto Home tab>Styles>Conditional
Formatting>Manage rules>New...
Word's Mail Merge of an Excel ListI am trying to follow the Excel help file in using Word 2003 to produce
labels from a list of names in Excel 2003. I want to just put the First
Name field on the labels. The instructions are very clear and I can produce
the labels just as I want them on the Avery labels except for one minor
problem. I want the First Name centered both horizontally and vertically on
the label. I can center it horizontally but can find no way to do it
vertically. The name in a large font size, say 48 or 72, is noticeably
nearer the top of the label than the center.
Is there a way to make it appear i...
setting up common headersI have a template set up that displays and prints six reports. Each report
contains a header showing:
Name of Client
Account#
Title of Report
Date Range of Report
Currently I have the header set up in each worksheet and I input the data
for each report.
I'd like to streamline this if possible,
The client name and number remains the same across all reports
The Title is specific to each report and does not change.
On some reports the date is a range and others it is either the beginning or
ending date of the specified range.
I'd like to input the Name, Number and date range ...
restore message from filled up PRIVHi
My Private IS reached 16GB. I did defragmentation, but it
didn't help. IS service couldn't start befor and after
reorganization. Of course I had to start my Exchange and I
had restored PRIV from backup.
Now I have to restore one message with attachement from my
damaged PRIV which I have not got in backup. Can anyone
help me?
Thanks for any help,
Andrzej
Which version of Exchange?
--
Cheers,
Steve Antonio
Microsoft Exchange Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Note: Please do not reply to this e-mail address. It is...
HOW DO I CREATE TAB DIVIDERS IN A PUBLISHER BOOKLETtrying to create a book where I can have tab sections for sub-categories. Any
ideas or experience welcome.
On Mon, 24 Apr 2006 22:00:02 +0100, epettus wrote
(in article <B91ADEB6-D25B-4211-8AC1-9CC12DFD69EB@microsoft.com>):
> trying to create a book where I can have tab sections for sub-categories. Any
> ideas or experience welcome.
To what purpose? Publisher projects are designed to be printed, not viewed
on-screen. Design your project, print it out and stick it in a ringbinder
with dividers.
Explain exactly what you want to do. How many pages is your booklet, will you ...
conditional formatting:highlight row based on blank or non-blank cDoes anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in that
row is non-blank (or blank)?
Thank you!
Hi,
Yes, first select your row then in your conditional formatting select
"formula is" from the drop down menu and type:
=ISBLANK($A1)=FALSE
or
=ISBLANK($A1)=TRUE
depending on weather you want the condition to apply when your cell is
blank or non blank.
HTH
JG
--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum....
how do i set up format for employee attendance monthlyi need a format of employees attendance which is how many sick days use, how
much absent days, how much vacation used and how many medical leave brought
in, and every month end a calculation and a percentage at the end of the
format.
Go to the Office Template Gallery and type attendance in the search dialog.
Or employee tracking
http://office.microsoft.com/en-us/templates/default.aspx
Gord Dibben MS Excel MVP
On Thu, 22 Apr 2010 12:03:01 -0700, mediumpeach
<mediumpeach@discussions.microsoft.com> wrote:
>i need a format of employees attendance which is how...
Add blank space to a cell if it's emptyHow can this be done in VBA?
Select some cells
For each cell, if the cell.contents = "" ; is empty
then set cell.contents = " " ; blank space
that's it
thanks!
Putting a space character in empty cells is usually a bad idea. If you have
formulas that use those cells, you may have to modify those formulas to treat
those cells differently.
But you could select the range you want and loop through the cells:
Option Explicit
Sub testme()
dim myRng as range
Dim myCell as range
set myrng = selection
for each mycell in myrng.cells
if mycell.value = &q...
Excel Linear Regression by set slope (not intercept)Hi Guys
is there a way in excel to get the linear regression function to
specify a function based on a set intercept (say =1), instead of a set
intercept.
I believe this ability should have been included in excel from day 1.
Answered under you post to microsoft.public.excel.misc. Please do not
separately post the same question to multiple newsgroups.
Jerry
"Ben" wrote:
> Hi Guys
> is there a way in excel to get the linear regression function to
> specify a function based on a set intercept (say =1), instead of a set
> intercept.
>
> I believe this ability s...
Setting up signatures that I have control overHi. I have Microsoft Office Standard Edition 2003 for
Students and Teachers and I have been trying to set up
Signatures for Outlook ever since I got it. In the past
when I had Outlook I could make several signatures and
click on a readily accessable button to have it
automatically inserted. It was fast and easy. Now it
seems that setting up signatures is a complex project.
The only time I get a signature is when I reply to a
message and then the same signature is inserted in the
reply. I would like to CHOOSE the signature like I was
able to in the past.
In my menu bar I have ALL E...
how change default set for email clientwhen we first time use outlook , it will ask to setup as default email client. so during access interenet , some webpage has contact us link to email, when click it will pop to outlook, but fo some reason, some use click cntact us in web , it will pop a outlook express. which is not my expected, how can i set it back to outlook
Thank
gary
...
Windows Mail Set UpI am trying to set up my windows mail to link with my gmail account. How do I
do it?
gmail help might be a place to start
"Matt Finch" <Matt Finch@discussions.microsoft.com> wrote in message
news:E53AE732-FBF0-4AAC-98C6-BC0D9E3FE1FF@microsoft.com...
>I am trying to set up my windows mail to link with my gmail account. How do
>I
> do it?
Gmail Help:
POP: http://mail.google.com/support/bin/answer.py?answer=86383
IMAP: http://mail.google.com/support/bin/answer.py?answer=77696
"Matt Finch" <Matt Finch@discussions.microsoft.co...
How to convert numbered cells into blankHi I would like to know how do i convert a blank cell to a 'completely' blank
cell. The blank cell is generated under the IF logic (under the " "); but
though we see in as a blank cell it is not completely blank. I need it to be
completely blank so I can plot the graph as non continous, rather than
registering as zero. Thanks for your help in advance.
Maybe this:
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=209
About 2/3 of the way down the page, look for
Gaps in Chart Series; Blanks Chart as Zero
--
Ryan---
If this information was helpful...
Even after selecting "skip blanks" in the paste special menu in e.Even after selecting skip blanks in the paste special menu in excel, it is
copying the blank cells
I think you misunderstand the purpose of "skip blanks".
Skip Blanks option will still copy the blanks, the blanks just won't overwrite
existing data if copied onto a range containing data.
See help on "skip blanks".
Gord Dibben Excel MVP
On Sat, 19 Feb 2005 04:25:02 -0800, "arudra1974"
<arudra1974@discussions.microsoft.com> wrote:
>Even after selecting skip blanks in the paste special menu in excel, it is
>copying the blank cells
Thanks for...
tax-line manager: 401k transfers on paycheck "before tax" tabHi. I'm using Money Plus. When I view the tax-line manager for 2007
transactions I have $0.00 for "Form 1040 > Your IRA contributions".
I currently have the portion of my paycheck that goes to my investment
account as a transfer on the "before tax" tab of the paycheck transaction
entry form. I believe that since this is a transfer I cannot add this
category to the tax-line manager. Is the tax-line manager working as I need
it to? I would have thought that I want the "Your IRA contributions" portion
to reflect the amount that has gone from my paychec...
Is it possible to merge two calendars? How?I am trying to merge my archived calendar with my current calendar to pull in
old appointments. I tried exporting the archived calendar to a Windows comma
seperated file and then importing it, but that did not work.
You can open the archive PST file using the File menu > Open > Outlook Data
File command then drag/drop the items you want from it into your active
calendar
"Grubbs" <Grubbs@discussions.microsoft.com> wrote in message
news:4E991D30-6654-4BAF-84C7-49F279B983FC@microsoft.com...
>I am trying to merge my archived calendar with my current calendar to pul...
Set up phone line for automatic dialing with broadbandHow should I set up to use Outlook for automatic phone dialing when using
Broadband?
Charles
You dont, yr Accounts Connection should be LAN
There is an option for how often to check for new mail, dont set it for less
than 10mins
"Sailor" <losailor@btinternet.com> wrote in message
news:cikf5q$523$1@hercules.btinternet.com...
> How should I set up to use Outlook for automatic phone dialing when using
> Broadband?
>
> Charles
>
>
...