add two cells from seperate work sheets into a cell on seperate wo
I have two cells on one work sheet that I want to add together in a cell on
another work sheet.
And is it possible to add together two cells on seperate work sheets in a
cell on third work sheet
When you say add do you mean sum and different worksheets are different
files? if the answer is yes and let's assume that the worksheet names are A,
B and C and the information is in that sheets in the tab called Sheeet1 and
the information is to be summarize in worksheet C
> I have two cells on one work sheet that...convert appointment to opportunity : link ?
There is a feature that allows us to "convert" an appointment to an
But there isn't any field that remember the link between the appointment and
Do you know a way to get it?
Isn't the activity listed in the Activities/History area of the Opportunity?
When you convert an appointment to an opportunity that appointment should be
listed as the only activity listed in the Activities (if you didn't close
the appointment when converting) or History (if you did close the
appointment when converting).
&...Filling cells in between pairs of numbers
I am trying to find an easy way to fill in cells in between pairs of
numbers each of which is exactly the average of the pair's difference
averaged by the number of these cells greater than the previous.
So I have
I know I can do a Fill, Series, but then even with a macro that does a
"control shift up fill series enter",...How do you add text to custom columns created thru the Field Chooser pls?
If I create a custom text column via Field Chooser - New, how can I
enter text into it afterwards?
I'm looking to add an "annotation" column and not have it sent if/when
I forward or reply to the message.
Outlook 2003 with Exchange 2003.
If you directly want to fill it out in the message list you'll have to
enable "allow in-cell editing" for your view.
The technique would be similar to;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://ww...fixed length within the counta and some text
I would like to generate some incremental number if the cell on the right
is not empty
How I can do this with this formula ? How i can convert the output of counta
to have 4 digits?
"Uma Shanker" <email@example.com> wrote in message
How can I open a Publisher 2000 version 6.0 document in XP?
As long as you are talking about Publisher 2002, you don't need to do
anything except open it.
MVP Microsoft [Publisher]
"jkingym" <firstname.lastname@example.org> wrote in message
> How can I open a Publisher 2000 version 6.0 document in XP?
"JoAnn Paules [MSFT MVP]" wrote:
> As long as you are talking about Publisher 2002, you don't need to do
> anything except open it.
...Formatting changes when copying or inserting text from other word
I have 2 documents... I need to combine the top portion of the first and
bottom portion of the second... they both have their own formattings. When I
combine them (Copy/paste or insert pages) the formating of the one I copy or
insert changes. I want the formatting of each of the decuments remain as they
were. As if I am combining 2 pdf documents.
How can I do this?
I am using MS Word 2000.
Be sure that the two documents don't have any Style names in common
(unless styles with the same name are absolutely identical in both
And put a S...Various Outlook 2003 issues
I've been using OL2003 w/ WinXP since it was released. I used various
other versions of OL for many years before that. In all that time, I
have never experienced the issues that have come up lately. I'm hoping
someone can help me resolve them.
1. In the midst of composing a new message or replying to a message,
the message format will change from HTML to plain text all by itself.
This started happening with replies to one person specifically but has
happened with increasing frequency and probably occurs with more than
50% of all ougtoing messages now. When I switch the message...How do I delete the "=" from a cell to give me the phone number I.
I have some data that I copied off a website and pasted into an excel
spreadsheet but I do not get the value that is displayed on the website. For
The information that was copied was a phone and fax number 1-555-555-5555
but when I put this information into my excel sheet I get -4500. If I look
into the cell the cell looks like =1-555-555-5555. I need a way to remove
the "=" from each one of these cells.
Hi, what I do in cases like this is to paste the info into Word first, do a
replace - stripping out the = sign and then copy and paste into exel.
...Publisher: Why won't my text wrap around a photo I have copied?
In Publisher 2000, it was dead straight forward... you pasted your image
inside a text box and the text went around it. In 2003, the text either
dissapears behind the image or gets transposed over the image.
>In Publisher 2000, it was dead straight forward... you
pasted your image
>inside a text box and the text went around it. In 2003,
the text either
>dissapears behind the image or gets transposed over the image.
Layers!! Select either the image or text box, then choose
Order from the Arr...Book/doc on converting XP program to work nicely on Vista?
Any good books or documentation, things I should know about what worked
fine on XP that won't work on Vista, what needs to be modified in the
program to get it to work nicely on Vista, umm, stuff like that?
What's a better way than Journal Hooks for a program to record it's own
keystrokes? Journal hooks was always problematic if other programs were
running that didn't process their messages correctly, and now on Vista I
hear journal hooks have been disabled.
try Microsoft Application Verifier.
"David Deley" <email@example.com> wrote in message
news:vTqVi.1...Using HYPERLINK Function in array formula
I've spent a good part of the day working on a few pretty complex
array formulas. I'd now like to add one that will create an array of
hyperlinks. I thought I could do something equivalent to:
....but I just end up with an array filled with google links...
Anyone have any ideas?
hi, James !
> I've spent a good part of the day working on a few pretty complex array formulas.
> I'd now l...VLOOKUP for a cell with both letters and numbers
I am trying to use VLOOKUP to find an exact match, the problem is that the
cell contains data that is a series of letters and numbers. I have used
vlookup to find and then return data successfully if the search cells are all
letters OR all numbers, but can't get it to work when both are present. I
have also tried formatting the cells to read as 'text', or 'general', neither
of which made a difference. PLEASE HELP! Thanks
Please give examples of the data you are using, the value you are using as a
key and the LOOKUP formula itself
"So...rewoving text boxes from a resume
my resume was scanned and emailed to me.
When I opened the file word 2003 there are text boxes all over the
I cannot cut and paste my document.
How do I reformat my document so I can edit and makes changes.
suetauber's Profile: http://forums.techarena.in/members/163050.htm
View this thread: http://forums.techarena.in/ms-office-support/1281312.htm
...split text in cell into 2
I am needing help with formula. I have a cell that takes values from several
other cells to create one long line text (for a command used in other app).
c1="There was a person named"&a1&"who was hungry and"&b1&" to Mcdonalds."
This process works great except when the line is greater than 72.
I need an if statment that says if c1 length is greater than 72 then to
split / replace line AFTER name(a1). Where the split occurs a +, and carriage
return needs to be added. So in the example above (pretend length will be
over 72,...Hyperlinks #3
I have buttons on my toolbar that hyperlink to oft templates. I've changed
the name, and that works if I show text on the toolbar, but the tooltip
always shows the full path - is there any way to edit the tooltip?
...Excel formula for seperating two words in the same cell.
How do I seperate two words in the same cell, seperated by a comma into to
seperate cells. eg. John,Smith (in cell A1) converted to John (in cell B1)
and Smith (in cell C1)?
Select column A and do
Data|Text to columns
and make sure you put the output in column B
> How do I seperate two words in the same cell, seperated by a comma into to
> seperate cells. eg. John,Smith (in cell A1) converted to John (in cell B1)
> and Smith (in cell C1)?
In cell B1 put =MID(A1,1,FIND(",",A1,1)-1)
In cell C1 put =MID(A1,FIND(...Ranking Only Visible Cells
I have a spreasheet with store numbers in column A and the store's sales in
column B. Example:
There are 70 stores but only 64 of them are OFFICIALLY generating sales. I
have hidden the stores that are generating sales UNOFFICIALLY and want to
rank the visible stores only.
Is there a way to rank only the visible cells? The hidden stores are
scattered throughout and will become "official" at different times, so
"hard-coding" the formula would be a pain (there are many of these
spreadsheets with different informati...how to change text of a part of a sentence automatically
I would like to know, how can I select part of a sentence Range object and
change it's text automatically.
The following macro demonstrates the simplest way to change part of the
sentence in which the cursor is located. Note that it doesn't do anything if
the search text is not found.
Dim OldText As String
Dim NewText As String
OldText = InputBox("Type the text that you want to replace.")
NewText = InputBox("Type the new text.")
.Text = Ol...Convert from GUID to String and vice versa
Hi Happy New Year,
how to convert from GUID to CString and vice versa ..A piece of code
will be appreciated..
Thanks with regards,
UuidToString and its counterpart UuidFromString are but a couple of options
available. Here is a link:
Make sure you understand the memory allocation for the returned string - pay
special attention to the reference to RpcStringFree note.
"San" <firstname.lastname@example.org> wrote in message
news:eLgraA57EHA.1452@TK2...VALIDATION DATA IN A CELL
Hi, can some one tell me if there's any way I put put some validation or
enforcement in a cell, where users HAVE to input something and it CANT be
left blank ? Thanks
What I usually do in a case like that is to use Conditional Formatting to
color the cells RED if they are blank, (ie = <> )and they turn white when
data is entered in them, then on the next function that depends on that
data, say a SUM function, use an IF to condition it, such as.........
=IF(COUNT(A1:A10)=10,SUM(A1:A10),"Red Cells must contain values")
Vaya con Dios,
"Chris" &l...Unable to use right-click on cells; standard and formatting toolbars disabled
I'm not sure what happened but a while back I started having problems
First, the Standard and Formatting toolbars are no longer displaying
in the toolbar area. When I use Customize toolbar they appear on the
Customize-Toolbar tab, but the check-boxes to the left are disabled
(i.e I can't check/uncheck them) .
Second, and really important for me because I use a lot of this
feature, in the working area, right-clicking no longer works. When I
right-click a cell, row, or column, no right menu appears with the
traditional copy, cut, paste etc or whatever. Noth...Excel 2007 text sorting problem
I apologize in advance for decidedly noob lingo...
In short, Excel is doing a very odd sort of last name/first name
columns in a worksheet containing data from two separate lists.
Here's an example:
Sandra H Bailey
B B BAILEY
JOHN S BAILEY
JON...Add formula to cell to sum range of cells
I am trying to write a macro that selects a range of cells and then format a
nearby cell to show the sum of that range. The code i have does so by
selecting the range, naming it, and using the name in the formula. The
problem is that I want to run this for multiple sheets in the workbook. I
can't figure out how to use a variable to name the range and use it in the
sum formula. Using ActiveSheet.name + "Days" in the sum formula creates an
ActiveWorkbook.N...converting lotus macro
I am an old lotus guru that is lost in VBA.
Can someone convert the following simple lotus macro to VBA? It compares
two values and moves one set or the other if not matched to align two series
of data. "\b" compares debits, "\c" then compares the credits. 5 minutes work
in lotus, years of frustration in excel! Hope there are still some old
123pro's out there who'll understand this.