How do I set up a daily average of unit sales formula
More info required.
(remove nothere from the email address if mailing direct)
"jim m" <jim email@example.com> wrote in message
...send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
http://www.slipstick.com/con...Special Pasting a work book with many sheets and formulas
I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
See this page for a code example
Regards Ron de Bruin
"lex63" <firstname.lastname@example.org> wrote in message news:ED708...Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
I have about 30000 lines of data that looks like so:
Where ColA is time. I am having trouble creating a graph with time on the
x-axis and count on the y-axis.
Thank you in advance.
You need to make an XY chart
But with 30,000 data points you could run into trouble; Help says you can
32,000 data points in a single data series.
However, if you want markers it will look like heck.
You could limit the data like this:
assume y-values in B2:B30001
in ...How can I get 32-bit Integers?
I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so as
to have 32-bit Integers, along with 64-bit Longs?
"Renny Bosch" <email@example.com> wrote in message
> I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
> is just 16 bits, i.e. its max value is 32,767. How can I configure it so
> as to have 32-bit Integers, along with 64-bit Longs?
An Access Integer is 16 bits. A Long Integer is...Cannot open Excel attachment from e-mail when Excel is already ope
This is driving me crazy. If I already have Excel open (with or with out a
spreadsheet open) I cannot open an Excel spreadsheet attached to an e-mail.
If I close Excel and retry it will open Excel and the spreadsheet.
Any ideas? I hate having to close all my open spreadsheets when I want to
open a spreadsheet that's been e-mailed to me!
One of these usually works with a similar problem starting workbooks by double
clicking them in Windows Explorer. Maybe one will work for you and your email
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close E...Mysterious e-mails
i keep getting e-mails that look and appear that they have
come from people either in my phone book or in some cases
from people that have ligitimately e-mailed me or that I
In fact the e-mail has come from somewhere else even
though the sender appears to be ligitimate.
Most of these e-mails are dated 3 or four weeks old and
show that they have been read in my inbox.
I've asked a few people if they have forwarded the mail to
me but they havn't.
Most e-mails are selling Viagra or some other product.
??? any clue ???
Thanks in advance
You're being spammed. First...INTERNET MILLION DOLLARS
INTERNET MILLION DOLLARS - www.InternetMillionDollars.biz
Watch the VIDEO on YOUTUBE... NOW!
MAKE MONEY INSTANTLY using 2007 featured
INTERNET MILLION DOLLARS as a resource.
WORK FROM HOME
HOMEBASED JOBS AND IDEAS
Professor James Bradley's
"Quick and real way to make BIG MONEY on the Internet!"
Finally you have FOUND IT!
Make a FORTUNE each month...
.... every month!
100% ON AUTOPILOT
Read it NOW and CHANGE YOUR LIFE!
Are you fed up with being short of MONEY all the time?
Do you DREAM about a...How do I get Powerpoint 2003 fade in 1 by 1 in 2007
I frequently used the 'fade in one by one' feature in Powerpoint 2003, which
allowed me to fade in individual bullet points by way of a click of a mouse.
Not only is this feature now not standard in 2007, but I can't work out how
to create it: anything that I find, tends, instead, to fade the bullet points
in on some kind of automatic time schedule, rather than - as I want - on a
mouse click. I want only to use text, no sounds, no pictures, and nothing
fancy. Currently, I am reduced to copying my material into an old Powerpoint
2003 presentation, but this is silly....product key #4
I have a product key for microsoft office which I purchased for my pc
several months back. I am now trying to use that same product key to
register office on my mac (office was pre-installed). Where do I
enter in this product key in the mac office trial software in order
for me to get full access?
In article <firstname.lastname@example.org>,
> I have a product key for microsoft office which I purchased for my pc
> several months back. I am now trying to use that same product key to
> register office on my mac (office was pre...Congratulations! This has been a MEB-free newsgroup for 4 weeks.
We all deserve a pat on the back. This has been a MEB-free workplace
for over 4 weeks - practically the entire month of June.
As Microsoft turns off it's usenet server and removes this newsgroup
from it's server, we have seen the last of Maurice Edward Brahier and as
this group continues to exist outside of Microsoft we will never again
see him post to this group. The fact that he has been a fraud and not a
real user of Windows 98 for many months if not years probably has
something to do with that.
His incoherent and rambling posts, written in a particularly obtuse form
...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...getting started
I'm installing office 2003, outlook, I'm lost from server type to URL address
to server info? I have sbc yahoo dsl. can you help me?
damselindistress <email@example.com> wrote:
> I'm installing office 2003, outlook, I'm lost from server type to URL
> address to server info? I have sbc yahoo dsl. can you help me?
When you obtained your packet from SBC, they included all that information.
Moreover, it's in the Help section of SBC Yahoo's site. The most likely
settings are "pop.sbcglobal.yahoo.com" for the incoming serv...Accommodating for empty cells in this formula?
I have a formula in cell H21, for example, reads like this:
is there a way to adjust the formula so that an empty cell in G21 doesn't
give the #VALUE! in subsequent cells in column H?
Just to give a similar example, this formula =SUMIF(A1:A9,"<>0") adjusts for
any and all empty cells in A2 to A9. It no longer matters if any of the
cells are empty, the formula correctly gives the correct addition of A1
plust a sum of everything between A2 to A10 without any #VALUE! results.
Was hoping to have the formula above als...how do you get a landscape page?
Please help, desperate!
If you are using 2010, Page Design tab, Size, More pre-set page sizes. Letter
landscape is the first choice.
In all other Publisher versions landscape will be on the page setup screen found
in the File menu.
"becky.x" <firstname.lastname@example.org> wrote in message
> Please help, desperate!
...Help With Margin Formula
I need help with a margin forumla (calculated from retail). Say I have a
cost of $10.00, and I need the formula to calculate a 40% margin from
retail. So the retail should end up at $16.67. Not sure how to get from
$10.00 to $16.66, I just know the cost and the margin I need to make.
"JR" <email@example.com> wrote in message
> I need help with a margin forumla (calculated from retail). Say I have a
> cost of $10.00, and I need the formul...Run time error 5 : HQClient
When I double click HQ Client I have message box "Run time error 5 : Invalid
procedure call or argument"
how should I do? I used RMS 2.0
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGr...Removing spaces from text #4
I'm in excel and i have a bunch of text data that has an extra space at
the end of the text on the right hand side for each cell. Is there any
easy way to remove this space?
Use the TRIM() function.
"lj" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I'm in excel and i have a bunch of text data that has an extra space at
> the end of the text on the right hand side for each cell. Is there any
> easy way to remove this space?
I tried using that function but the results st...Setting appointment start & end time increments format
In Outlook 2002, I can easily set the Day View to display
the time increments in 15 minute blocks, but on the
Appointments form, the Start and End Times available on
the drop-down menus, respectively, are in 30 minute
increment blocks only. How can I set the format for the
appointment page to have the Start and End Times for
appointments have increment time blocks of 15 minutes?
Thanks! My direct email address is:
If you set your appointments in 15 minute blocks
Outlook will start to offer that. It takes a few uses
Nikki Peterson [MVP ...Status Bar #4
Hi - can anyone tell me what the "official" name is for the facility on the
Excel Status Bar which allows you to select a range of cells and view the
Sum, Average etc of those cells?
It's the AutoCalculate feature:
AutoCalculate feature is working even if that feature is turned off
XL7: CTRL+Click Selected Cell Changes AutoCalculate Value
> Hi - can anyone tell me what the "official" name is for the facility on the
> Excel St...how to know how many e-mail each user receives per day?
We are running Exchange 2003 on Windows 2003. I would like to know how to get
an average of how many e-mails each users send and receives per day.
...OLE Notes #4
Windows Server 2000 SP4
MS SQL Server 2000 SP4
MS Dynamics 9.0 SP3
When a note is entered on a vendor card (Cards, Purchasing, Vendor, Note
icon) a dialog box titled OLE Pathname appears. The purpose is a shared
If the user clicks ok or cancel without entering a path, where is the note
I have two vendors that have the exact same note, entered at the exact same
time, by the same user. In theory this should not be possible.
The OLE path is not specified in the dex.ini file.
Did you not find the note in SY03900 table on the company? The vendor c...Formula to count the number of different values in a range
I'm looking for a formula that will give me the number of different values
in a range.
Example: Column A may have five cells that are "4", five cells that are
"7", five cells that are "9". Of the fifteen cells that contain data, there
are only 3 different values. I'd like to use a formula that will count the
number of different values in column A, in this case the result is "3".
=SUM(IF(A1:A15<>"",1/COUNTIF(A1:A...Auto Delete the e-mail
We are using Microsoft Exchange 2003 and Outlook 2003. One mail box calls
"Sales", i configured the achieve function for this mail box, this function
will automatically delete mail if the mail is order than 7 days. But this
function is not running if the outlook closed, is it possible this function
running on server only, no need to open Microsoft Outlook for running the
achieve function in client PC ?
Philip Tsang <firstname.lastname@example.org> typed:
> Hi all
> We are using Microsoft Exchange 2003...