The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <email@example.com> wrote in message
news:08D989CB-D1B4-49F...Need Syntax for "AND" to Evaluate 2 Cells
I need to evaluate 2 cells while inside an "Private Sub
Worksheet_SelectionChange(ByVal Target As Range)". I thought AND would work
but I cannot get it to work; I receive a syntax error on the AND(Range...
Can someone please provide me the proper syntax to evaluate the 2 cells?
Here's my code...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name = "Sheet1" Then
And(Range("I3") <> "", Range("K4") = "") Then
Range("K4") = Range("K3")
End...Adding Contacts Folder as Address Book in Exchange Server
I am trying to add my contacts folder to my address book in Outlook XP and
don't see the Tools, Options I used to see in Outlook 2000. How can I add
this folder to my address book? Is that an option you can turn on or off
for a profile in Exchange Server?
Remove 'spam' from email address to contact me directly
Right click on your Contacts folder, go to properties, outlook address book.
Can you tick the box there?
If not, go to tools, e-mail accounts, view/change address books, and make
sure you have the Outlook Address Book option there. Then try right-clicking...selecting a cell
I seem unable to select a single cell, or a single row--click on one in the
normal manner, and the two below also highlight, then delete or whatever
command is given. If I input a number/text, that just goes into the one
cell. tapping F8 increases this to two wide and three high automatically
Also, very slow to do almost anything.
Are you by any chance using Excel 2007? If so there is a known bug that
causes multiple cell selection and I understand this has been reported to
If you take the zoom level up and down this is reported to cl...Enter "1", cell show ".01". Why?
Any number typed into a cell is divided by 100.
If proceded by "=" the number is correct.
What caused this and how can I fix it?
Try this ..
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
Things should be back to normal now ..
(it's a fixed decimal setting !)
"Yonian" <Yonian@discussions.microsoft.com> wrote in message
> Any number typed into a cell is divided by 100.
> If p...Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Adding an "I'm out of the Office" Message
Re Outlook Express. I can't find anywhere on the index
about how to send one of those "I will be out of the
office from July blah blah to August blah blah." Anyone
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to an
Outlook Express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexp...cell will not center
I have a user with an Excel worksheet. There are multiple rows and columns
and they are all set on center alignment, (center alignment icon on the
toolbar as well as Format Cells --> Horizontal Alignment --> Center.) The
alphabetical characters align correctly but the numerical don't, as they will
only left align. Format Cells --> Number is set to General, so I don't know
why it won't change the alignment.
Other than the worksheet being corrupted, I don't know what could be wrong
Any suggestions are much appreciated.
=?Utf-8?B?SG...Count # of cells b/w cells ...
I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0
0 0 0 0 0 7 etc.
The number of zero's between the 7's is random. I want a formula tha
would count the number of zeros between the 7's.
AriBari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2504
View this thread: http://www.excelforum.com/showthread.php?threadid=38806
Assume A5:A20 is the data, try this:
B5 = A5+B4 (copy formula down)
Now make a table with 2 column...Too many different cell formats #6
I am running into the error message:
Too many different cell formats
Is there a solution to lowering the number of formats I
am using? Just trying to change them to make some
consistent gives me the same error message.
I tried running the search on the forums on my topic but
they have been disabled for a Microsoft upgrade.
One idea -
Rob Bovey's excellent Utilities add-in will list all the formats in use in
your workbook, allowing you to manually delete what isn't being used.
You can also see the source code for ...organizing hotmail emails within outlook 2003
At home I have outlook 2003 on windows xp configured so that my hotmail
email is picked up in outlook. I have outlook on exchange at work and
have found that organizing my email by color is invaluable. I tried to
organize my hotmail email by color and with rules, however outlook will
not let me do so. Is there a way around this? If I could get the mail
in my hotmail account into the main default "inbox" under personal
folders in outlook then I can organize the email how I want to, however
when I try to do this I have no success in doing so.
colors are controlled by views, not r...format cell #4
In Access, I can set up a field that "forces" the user to enter info - a
date, for example - in a certain way, such as 25 Jan 05 or enter time as
12:15 AM. Is there a way that I can "force" this in excel?
Without invoking something more technical, you can select the cell(s) and go
to Data>Validation and choose what type of entry be allowed in the field.
Format the cell in the manner you wish to have the date or time expressed.
> In Access, I can set up a field that "forces" the user to enter in...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Find and replace with bold in cells
I have a VB6 program that is executing Excel 2007, opening a worksheet, and
extracting some of the cells to write data to a text file. Some of the cells
contain bold text on some (not necessarily all) of the text in the cell. I
would like to do a find and replace on the bold tagging to replace it with
something like "<b>" at the start of it and "</b>" at the end of it. How do I
set this up in VB6? Thanks!
The following function will return a string including <b> and </b>
tags from the text of cell R.
Function BoldMarkup(R As Range) As...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Conditional Formatting on cells beginning with a hyphen
Is it possible to do conditional formatting on cells beginning with a
1. Place the cursor in A1 cell and select the Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and paste the below formula
4. Click Format Button>Font>Color select your desired font & Background
Color pattern and then give ok
Change the cell reference of A1 to your desired cell, if required.
But keep in mind that when applying the conditional formatting the Active
cell should be in the ce...how to insert borders on flyer within Microsoft publisher?
Please help, I'm trying to insert a border around a flyer...I'm using
Is it a clipart border, Borderart or a simple rectangle? What problems are you
having? What version Publisher? Any border you insert should be sent to the back
so it does not interfere with your main design.
Mary Sauer MSFT MVP
"Harriet" <Harriet@discussions.microsoft.com> wrote in message
> Please help, I'm ...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...modify linked cells without breaking link
I have a workbook with a number of worksheets (2003.) The 2nd and 3rd
worksheets have cells that are linked to the 1st worksheet. This workbook
will be used to schedule production. The 1st worksheet has a list of products
that we produce.
The 1st worksheet has a column for the min # of cases we need to keep in
stock at all times and the max # of cases we must keep in stock at all times.
The 1st worksheet also contains a column where the production scheduler would
enter the actual # of cases in stock.
The 2nd worksheet in the workbook takes the actual cs in stock and compares ...Add data to cell w/o loosing initial data
I would like to know if there is a way to add data to data without retyping.
For example I have a colum of 18015555555 and I want to add [rfax:(cell
#)@/fn=(phone number)] So I would like to add the brackets - copy from a
cell - @/fn= and not loose the data already in the spread sheet. Example 2.
Add [rfax:company name@fn/=(saved data here) then close bracket.
So I want to add data to cells without loosing the data already in the
cells. I have about 600 of them to do and I really don't want to do each one
Please let me know if anyone knows how to accomplish this.
Tha...Limit number of characters in a cell
Is there a way to limit the number of characters that a user can key into a
I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.
Thanks for the help
Take a look at Data|Validation.
You can have excel yell at the user when they hit enter after typing in a
Dr Senji wrote:
> Is there a way to limit the number of characters that a user can key into a
> I want to get a list of names and addresses imputted by user, but I don't
> want the...how do I format cells to change date and time to just date
I want to format a column that contains date and time and I want it to show
just the date and not the time. Going into format and clicking on the date
and changing doesnt work.
Probably the cells aren't really dates, but text. You can check with the
If they are text, formatting doesn't have any effect.
Microsoft MVP - Excel
"bondam" <firstname.lastname@example.org> wrote in message
>I want to format a column that contains date and time and I want it t...