hey ya'll how do i auto sum a cell using the letter x instaed of .
hey ya'll how do i auto sum a colum using the letter x instead of using a
To count number of "x"es
Gord Dibben Excel MVP
On Mon, 25 Oct 2004 14:25:04 -0700, jrod98 <email@example.com>
>hey ya'll how do i auto sum a colum using the letter x instead of using a
Gord answered but I couldn't resist asking what the sum of x and x is?
Sinister Rod Serling music here.
"jrod98" <firstname.lastname@example.org> wrote in mes...paste text into a used cell
I need to move text from one row to a single cell that has been formatted to
wrap text and repeat the process for other rows.
Paste is not working. Please advise.
When you copy and paste, you paste the format as well as the contents
If you want to copy text to a cell that is formatted differently
instead of paste, slelct paste special, values
ElsiePOA's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=390
View this thread: http://www.excelforum.com/showthread.php?threadid=26962
...How can I use the exchange mode in Outlook? Can I use it in my PC
Can I use it in my PC? To use it I'm supposed to have Microsoft Exchange
Server 2003, but what is that?
Using the exchange mode in Outlook, if Outlook makes a security copy for my
emails, that means that if an email has a virus, it gets saved in my PC?
If by "Exchange Mode" you mean use an Exchange server in "Add / Edit
Email Accounts" you can't - unless you are connecting to an Exchange
server (which is often the case in larger companies).
If you had an Exchange server, I suspect you would have been informed
by your tech staff - so my guess is that the answer...COUNTIF using amount of time
I have some data with various time intervals in mm:ss.ms and I want to
use the COUNTIF function to count how many of them fall between 1-2
minutes, 2-3 minutes, 3-4 minutes, etc., but I keep getting a count of
all the values. Am I comparing the time intervals wrong?
For example, the data (in the A column) is:
My formula for counting those between 1-2 minutes:
The returned value is 6.
Any help would be appreciated,
For 1 to 2 minutes, try
=SUMPRODUCT(...to use workday function in excel vba code
is there a way to use wrokday function in my worksheet controls.?
i have a date time picker in my worksheet and a text box and a button.
on click of this button i should get next desired date.
like when i select a date from the calendar and click on button ther
is onclick function in my macro.
this onclick should calculate next desired date(assume if i choos
10/11/2005 and add 2 to this date i should get 12/11/2005)
i know how to use workday function using a cell reference
i don't know how to put this into a vba code.
if i use workday("10/11/2005&qu...Using a sub procedure to change a subform property
I am currently using the following code to change the AllowEdits property on
any form. The form calls the Sub procedure through a button's OnClick event.
Sub UnlockForm(strFormName As String)
On Error GoTo Err_unlockform
If Forms(strFormName).AllowEdits = False Then
Forms(strFormName).AllowEdits = True
MsgBox "Form is now unlocked for editing."
I am trying to call this Sub procedure from a button on a subform. I was
going to us...Handling more than one email template
I'm a freelancer and depending on what company I am doing work for I'd like
to set up Outlook to use more than one email template (html stationery
Currently, Outlook is set up that one stationery style is used no matter
what mailbox account I use. I'd ideally like Outlook to apply a stationery
style depending on what email account I chose to send the email from.
It's easy in Outlook Express as you just chose the stationery style from a
drop down list. But I can't find a quick way of how to change stationery
styles in Outlook.
Any advice would be very...CheckBox in a Dialog
I have a check box in a dialog (.rc).
I want the check box to show the state, I meen, if the
user pressed the check box - it is with "vi". I update a
variable that the user chose it.
When the user goes to other page and then returns to the
same page, by checking the value of the variable, I want
to put "vi" in the check box, in a case that he chose it.
How can I do that the "vi" will appear on the check box?
I checked in the help and found -
public: __property CheckState get_CheckState();
public: __property void set_CheckState(CheckState);
for c++ b...Use of Dialog
Hi all, I'm curious about use of excel dialog. What is for? and how to
use it and what other benefits or advantages in using for common
Thank you. :)
markuss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34966
View this thread: http://www.excelforum.com/showthread.php?threadid=553085
Dialogs can make things easier for you and your end user. They can be used
to pre-validate entered information, apply business rules to it before
placing it onto a w...Templates in Office XP
Is there information about the template use in Office XP?
If it is in spanis much better
The following page has information on using Templates in Excel, and you
can choose Spanish from the Language dropdown:
> Is there information about the template use in Office XP?
> If it is in spanis much better
Excel FAQ, Tips & Book List
...Use Folders for E-mail
I organize my e-mail message into folder by client or topic.
When I look at a message in the "sent items" folder it is shown under
the name of the person to whom I sent it.
However, when I drag that same item into a client or topic folder it
is now shown under my name, apparently since I was the sender.
Is there a way to force the dragged item to keep the same name as it
had in the sent items folder?
All you have to do is switch the view on the client or topic folder to "Sent
To" -- that's the view used in the Sent Items folder by default.
Jocelyn...Inserting blank rows plus using Sum
I have a list of stocks sorted by date. When the stock symbol changes, I
need to insert 2 blank rows and AutoSum columns 2, 6,7, and 8 of the group
and display them on the first of the 2 blank rows, leaving a blank row before
the next group.
Symbol Qty Price Action Name US Trade Date Amount Commission Fees
MSFT -210 28.95 Sell 2/13/2008 6079.43 -0.07 -0.07
MSFT -790 28.95 Sell 2/13/2008 22863.24 -7.26 -0.26
-1000 28942.67 -7.33 -0.33
C -700 22.16 Sell 3/4/2008 15511.82 -0.18 -0.18
C -300 22.15 Sell 3/4/2008 6637.92 -7.08 -0.08
-1000 22149.74 -7.26 -0.26
MSFT -500...Not able to send mails using Ms Outlook 2000
Whenever i try to send mails using Ms Outlook 2000 i get
SMTP-MAIL: died on signal 11', Port: 25, Secure(SSL): No,
But i am able to send the same mails with same id
configured with Outlook Express 6 and 5 both
What will be the solutions to this
What you try to do is to export your mailaccount setting
from Outlook exprees into Outook 2000
>Whenever i try to send mails using Ms Outlook 2000 i get
>SMTP-MAIL: died on signal 11', Port: 25, Secure(SSL): No,
>But i a...Ignore table formatting when importing data using OLEDB
I am using Excel 2010. I want to write a macro in a 'consolidate' XLSM
file that will query another selected XLSM file and import data from
one of the range names in that file, into the 'consolidate' file.
When the import occurs, it formats the imported table using the
default Excel 2010 table style (see screenshot), however i don't want
to format the cells - i just want to import raw data and leave the
cells formatted as they are in the 'consolidate' XLSM file.
The PreserveFormatting property has no impact, as the damage is
already done once the query is added.
...Two problems: Printing PPM image and accessing the generic Print Preview when using static MFC window
I can print IPicture objects with no trouble (drawn with
Ipicture->render). But when I do it with PPM/PNG drawn with
StretchDIBits I can see it on the screen and also in print preview, but
the printed page is empty. Is it possible to do it, or can I wrap my
BYTE array containing the image into an IPicture pbject and draw it
I also have trouble with print preview in static MFC DLL. When I click
print preview a warning window appears (with an empty string) and I can
click OK and it ignores my attempt to open print preview. In debug mode
it says there was an a...Using Delete Dialog
I try to create a Custom Web Page, which will insert to the CRM by NavBar.
This is working fine.
Now the should be a seperate Button, for deleting.
I found a way to call the standard delete dialog with:
My Problem now:
How can I set the id for the Case which should deleted?
When I set the argumten like:
I get the error:
"XML Parse...Picture viewing in outlook 2000 using XP
Using outlook 2000 standard (no updates). XP Home with all SP's and updates.
I view picture attachments using the default picture and fax viewer.
When the last picture is viewed. I click next. Instead of restarting the
same file, another file appears. It is always the same picture file that
appears regardless of which email I am viewing. I have removed the intruder
picture file from the C drive(MY Pictures) and from outlook (sent items).
This intruder still happens. Any ideas ???
Metro Pete <Metro Pete@discussions.microsoft.com> wrote:
> Using outlook 2000 standard (no u...what pdf software do you use to redact text?
There are a lot of software packages that will converted back and forth
between Word and PDF documents - however, I need to know if anyone uses a
good converter that will allow true redactions that cannot be seen in the PDF
version as well as remove metadata from the output document.
Do your redaction in Word. Output the document to a graphics format such as
TIFF using SnagIt's 'printer' driver, then print the results to PDF using
Acrobat to combine multiple pages. That should stay redacted :)
<>>< ><<> ><<> ...how can I use a picture to fill text?
I am trying to use a big balloon font, and have a picture as the fill color.
How do I do this?
Create the phrase with WordArt. Fill, Fill effects, Picture tab.
"lee254" <email@example.com> wrote in message
>I am trying to use a big balloon font, and have a picture as the fill color.
> How do I do this?
...Mysterious question mark (?) when using OWA
Mysterious question mark (?) when using OWA
It seems that my users whom use OWA to send email always seem to send along
an "?" question mark at the beginning of their email messages. I am trying
to find out why that is happening and how to go about eliminating it.
If clients are XP SP2, check kba 883543 and apply the hotfix.
Pe-XP SP2 clients: reinstall the S/MIME control from OWA - options.
"Mr. Backup" <firstname.lastname@example.org> wrote in message
new...Using a variable to refer to a control in VBA
I was wondering if any one can tell me how to fix the 3rd line to work like
the 2nd one does. The 2nd one works fine but one the 3rd one they system
throws an error.
Dim intloop as integer
Forms![frmDate]![frmsubMonth].Form![subForm8].visible = False
Forms![frmDate]![frmsubMonth].Form!("subFrom" & intloop & "").visible = False
Dale K wrote:
>I was wondering if any one can tell me how to fix the 3rd line to work like
>the 2nd one does. The 2nd one works fine but one ...Money Template Designer? HELP!!!
I recently made a leap of faith, and purchased MS Money
Small Business 2004 over QuickBooks SB. Now I have an
issue, that mus be resolved, and I am sure, this is
I have a portrait style 8x5 invoice sheet, with static
text on the top(which can be the coimpany setup info),
but i need to add custom fields for both the company, and
for clients, and pull those fields into the template.
What am I missing? I tried the help, with no luck,
browsed the newsgroup, nothing. Basically, I need it to
look like the statement printout, but customized.
Thank you, to whoever, for your time!
...error converting SBF to GP using Migration Wizard
Running the Migration Wizard to convert SBF to GP. Got error: Conversion
failed converting varchar value 'stn42150' to data type smallint. This was
during the BCP DU000010 Started step.
What does this mean? What do I need to do? Thanks!
...Is there an academic year calendar template?
I'm looking to create a quick calendar from July-June.
> I'm looking to create a quick calendar from July-June.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
...email templates 01-27-05
Does anyone know what security needs to be set in order
for all my users to be able to see organizational
templates? Currently, only half my users are able to see
organizational templates and the other half are only able
to see personnal. I'm trying to figure out if there is a
certain security that is needed on another entity (leads,
accounts, contacts) that affects what is seen for
Check the "Email Template" object on the core records tab. It sounds like they
will need to have "Global" on that.
MVP - Microsoft CRM