Help Journal Names
I use the Journal all the time to help track what I'm doing
For journaling items such as excel files, and word documents, it would
preferable to show just the name of the document rather than the full path
to the document (which appears on mouse-hover anyway). My paths tend to be
long, so the only way I can find the name of the document is to mouse over.
Anybody know if there is a way to just display the document name - without
the path information?
Thanks for any advice.
Cut off: yourhead to respond
...Formula help #41
Been trying to get this right, and I think it is simple but I am not getting
it. What I have is: Column B “amount Rec’d”, Column C “Purchases”, Column D
“Cash out”, Column E “Balance”. I am trying to put together a formula in
Column E that will only give a result when data is entered into either B, C,
or D. Then be able to copy it all the way to row 36, and not have anything
in Column E until data is entered into the corresponding row. I know this is
easy but I am not getting it. Please Help
Will you always enter data in B1, C1 and D1 as a group? If=20
I have a tricky excel macro opportunity.....
My sheet(s) consist of sales data for a number of companies, populating
columns A through to O.
Column A lists company names.
Column M lists Sales $ achieved.
Within column A, there may be a group of identical entries (company names)
that are differentiated somewhere else in the sheet.
What I would like to do is sort by group of companies first, so the group of
like named companies in column A with the greatest
aggregate total of sales in column M should be listed at the top of the
sorted list then each of the comanies within the gr...Removing Blank Rows #3
I have an excel workbook with three sheets:
This sheet has three columns. Column A is simply a set of random
numbers. Column B is empty and is designed so that the spreadsheet
user can place an x next to values in Column A that the user would like
to "mark". Column C has an "if" formula that basically says,
=if(B1="x", A1, "")
So now, any "A" cell that I select by placing an "x" in the "B" column
is copied into Column C.
I'd like Column A in this sheet to pull the values from Column...Help descriptions in Save, Save As windows
In Office 2004, I've noticed that the Save and Save As dialog windows=20
contain toward the bottom a box with help descriptions that change as =
mouse over various options. Office X had this feature only in the =
window. Is there any way to turn this feature off in Office 2004?
In article <firstname.lastname@example.org>,
"B McNeill" <email@example.com> wrote:
> In Office 2004, I've noticed that the Save and Save As dialog windows
> contain toward the bottom a box with help descriptions that change as you ...on line help can't find the word 'customer' (or anything else)
Any idea what Im doing wrong? Surely this must work : )
1. From the CRM 'My Home Page' click 'Help' from the
2. From the resulting drop-down menu box select 'Contents'
or 'User's Guide' (either selection seems to bring up the
same help content).
3. The CRM Help system menu appears, with a 'Find' text
entry box available at the top of the page. Enter the
word 'Customer' and press the 'Go' command button.
4. CRM help responds with the following message:
No results were found that matched the query "cu...Sorting in different culture
When we sort for example an array of char it's the numeric value for the
character that is used to decide which one is greater then the other.
But my question is if we look at other language and culture how is the
sorting done there is it based on the numeric value for
the character to decide which character is greter then another.
I mean in english if we have the character cba it could have been
implemented without using the numeric values for the character. So the
sorting of cba might have given bac.
Tony Johansson wrote:
> When...I keep geeting Send and Recieve Error 0x 800 40 900 Help ???
"Neil" <Neil@discussions.microsoft.com> wrote in message
Recheck your pop3 settings.
"Neil" <Neil@discussions.microsoft.com> wrote in message
...Please Help Formula
In column A I have let's say 1000 numbers. In cell B1 I want the
average of cells
A:10, A:20, A:30, A:40 etc. etc. A990:A1000
How can I copy the formula to 1000.
I hope someone can help me.
melle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26981
View this thread: http://www.excelforum.com/showthread.php?threadid=473345
You're asking how to get the average of the values in every 10th cell, right?
=AVERAGE(IF(MOD(ROW...bar graph #3
I am making a simple bar graph. every time I go to change the x axis from
numbers to year dates, the bars disappear???
What values are you setting the axis to?
What are the min/max values of your data?
Andy Pope, Microsoft MVP - Excel
"adag59" <firstname.lastname@example.org> wrote in message
>I am making a simple bar graph. every time I go to change the x axis from
> numbers to year dates, the bars disappear???
min 1996 max 2007 values 1/years
"Andy P..."Adding" Named Users to Business Portal (3.0 or 4.0)
A client of ours already has Business Portal, but they want to set it up
with 25 Named Customers to be able to view their invoices, shipping, and
The time to set this up is pretty nominal, isn't it? I mean, is it a matter
of simply entering new registration keys and showing the customers how to use
the Portal or is there a lot more work involved than this?
Nevermind....I researched and got my answers
> A client of ours already has Business Portal, but they want to set it up
> w...Toolbars, help needed
I would like to have a workbook that opens in full screen, but only for this
particular workbook and not in other Excel workbooks.
You could use the workbook_Open() and close() events as in the code below.
This would switch on full screen when opening and restore when closing. To
enter the code, right-click the excel icon at the top left of the workbook
and select 'View code...'. Then paste the code in resultant window, close
the VBE and save the workbook
Private Sub Workbook_Open()
Application.DisplayFullScreen = True
Private Sub Workbook_BeforeClose(Cancel ...Mail Merge Functionality in 3.0
I am told that customizing mail merge documents for MSCRM 1.2 is very
limited. Example, you cannot add any desired additional fields on the mail
My question is, in MSCRM 3.0 can this be done? Or do you still need to
purchase a third party add on program?
Thank you in advance for your help!
hmmm sort of looks like you can use custom fields in everything apart from
activities...I have not tried it yet...anyone care to comment?
Microsoft CRM MVP
http://www.microsoft.com/businesssolutions/crm/community/microsoft_crm_co...Report help #2
I have a report “Detailed Sales Report with Total Discount” from the customer
source page. Is it possible to ad “sale rep” to filter options. We leave the
pos lanes open to a default cashier and each person (sale rep) logs-in for
each transaction. I would like to show detail/totals for the discounts given
by sale rep not cashier. Any help would be appreciated.
Yes you can accomplished this.
1. GO to %installpath%:\Program Files\Microsoft Retail Management
2. Open the Custom - Detailed Sales Report with Total Discount.qrp
3. Add the following line before t...how do I insert a title page to a 3 page research paper
How do I insert a title page to my 3 page report
If you're using Word 2007, go to:
If you're in an earlier version of Word, go to
> How do I insert a title page to my 3 page report
...Dynamics Security console #3
I have installed MOSS onto a windows 2008 32bit server. I have done all the
setups and have installed Dynamics Webservices with SP3 all went fine. When I
run Dynamics security console and choose select Applications and the
SecurityService. I get a "Could not access the SecurityService service.
Unable to connect to the remote server"
Please could somebody help
...My 14yr old can't help
My smart 14yr old can't help me!
I want to put data into column a, 100,000 thru 2,000,000.
A1 is 100,000, a2 is 110,000, a3 is 120,000, etc. all the way
to 2,000,000. ie, column a increases by 10,000 as it goes down.
Can this be done by a calculation? I don't want to type in all these
Get a 13 year old
highlight both>goto lower right corner of a2>grab the cross>drag down
"amdx" <email@example.com> wrot...Sorting, Grouping and Calculating in a Query
I want to pull out customer name & addresses based on purchase amounts for
over a certain amount (say $1000) over a certain time period. My fields are
all available in one table, but I also have many of the fields in other
tables as well. Fields include customer no, name, address (blah,blah)
invoice#, date and paid (total for a specific invoice). I can calculate the
time period with criteria either in the invoice number or date fields.
I'm able to get the totals (using the sum function) by customer number when
I use just those two fields, but when I add additional fields to the ...Help with setting up a formula
Hi. I need some help setting a formula for the following:
Info on Sheet1
Operation Item A Item B Item C
1.Cut 10 min 12 min 15 min
2.Trim 22 min 19 min 17 min
3. Polish 13 min 14 min 16 min
Info on Sheet2
01/11 02/11 03/11
Item A 9 units 5 units 5 units
Item B 0 units 2 units 3 units
Item C 0 units 2 units 1 unit
Info required on Sheet3
01/11 02/11 03/11
1. Cut (tot min) (tot min) (tot min)
2. Trim (tot min) (tot m...Professional Data Recovery Software Development Help
I am the Author of Book titled, �'Data Recovery with & without
I provide ONLINE ' data recovery training'
(http://www.datadoctor.biz/DRCguide.htm) (Professional Courses ).
If any forum member has any Computer Data Recovery related query or
interested in Data Recovery knowledge sharing or You've any Data
Recovery Software Programming related issues, I'll be happy to discuss
If you�ve any query or comments, feel free to mail me�
'Tarun Tyagi' (http://www.datadoctor.biz/author....Please help! #5
I need to create a menu type system that will allow people on my LAN
to access regularly used Microsoft Excel 97 files.
I know there's probably a dozen ways to do it but I'd love to hear
I've been toying with using a html page that has links to the excel
files so that they can click the link and have the file open
automatically but I'm finding that it works only very sporadically and
on some machines but not others.
What are my options?
i see no real advantage to what you are trying to do
but why not set up a master xl file. put buttons up on th...Need help vlookup?
Need to put a value in the blank column #N/A using the ss#. If the ss#
matches, then the value on Worksheet SAPCODE worksheet.
FINAL SHEET (name of workbook)
COLUMNS AW and AX (ROW1 has headers)
Row two begins data
Column AW is a list of Social Security Numbers
Column AX is a number code I need to get from another worksheet (currently
Following Columns and Previous columns contain misc data
COL AW AX AY
1 SS# NEEDED CODE INDICATOR EXTERNAL...Moving Formulas when Sorting
Hi All & Happy Christmas & New year,
How can I sort a table and have the formulas move to the relevant new
I'm working on a World Cup spreadsheet so I've got each table as follows
a b c d e f g h i
P W D L F A Pts GD
The fixtures are below the table and this is where each teams results are
from in the table.
In cell C2 (Team A Won) the formula is =SUM(A11+A15+K21)
In cell D2 (Team A Draw) =SUM(B11+B15+L21)
These formulas...The picture is too large and will be truncated #3
I developed a fairly large XL97 file with macros that has been used for two
months by 5 users. One user just got a new computer with WinXP and XL2k.
Every time she opens this file now, she gets the error message "The picture
is too large and will be truncated". The file is on a network and still
works fine for everyone else. And, this computer will open another large
Excel file with macros without giving the error message. Any ideas please?
Vaya con Dios,
Something to try...
have the user change the screen resolution and/or updat...re: Cannot send Internet Mail...HELP PLEASE
. Reply (E-mail) Forward (E-mail)
Subject: Re: Re cannot send intenet mail....HELP!!!
From: "todd" <firstname.lastname@example.org>
Sent: 5/3/2004 9:27:50 AM
Ok, I deleted the MX record on the mail server. I
successfully used telnet to send a test email to my server
at home with no errors. But Exchange 2003 still WILL NOT
send any mail to ANY outside domain. I can't beleieve how
much time I have spent on this. Please advise.
>Your external MX record has nothing to do with sending