How i can add description tail to cursor when it goes on to a spe.
How i can add a description tail to a cell when i move cursor to that
specific cell. For example if i move cursor to cell A2, it should give a
description tail "add value from code 1202"
I think you want something similar to the ScreenTip you get when you
highlight a button on the toolbar. Excel only offers ScreenTips for
hyperlinks only. You will have to make the cell into a hyperlink and then
click on ScreenTip in the top-right corner. This works with formulas.
It might be better to use a comment. Right click a cell and click "insert
comment"....zero value in cell
I have a table of engineering calculations. The same formula in each cell
operation on variables in the row and column headers. i use the MIN function
to evaluate two formulas. Then I take the minimum result and operate on it
outside of hte MIN function. I'm getting zero values displaying in my table.
When I pick a particular cell, and then pick the formula icon in the editor,
the dialog box displays the correct reults for each of the two items and the
formula overall. Why don't these results show in my table?
I'm guessing your numbers are actually Text....want questions
I want some set of questions on Word-2007 to check competency level of the
user. Please help.
Ananta, please refer to my other 2 postings: just check out the WORD part.
If my comments have helped please hit Yes.
"Ananta Gupta" wrote:
> Hello Everyone,
> I want some set of questions on Word-2007 to check competency level of the
> user. Please help.
> Ananta Gupta
> Ananta, please refer to my other 2 postings: just check out the WOR...Auto Complete tasks from Sales Process when stage changed
I have set up a sales process with 6 stages with 4 tasks each. When An
Opportunity is created it automatically creates the sales process and stage
is Stage 1. When I change the stage to Stage 4, how can I make all the
activities/tasks in the previous stages as completed as at the moment they
display as either open or pending?
you can do this through workflow or writing .net assembly to mark them
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
"Sukh&q..."criteria" in a sumif refering to the value in another cell
I'm trying to do a sumif with the "criteria" refering to an adjacent cell
rather than having the criteria hard keyed into the formula. For example, if
I have a list of purchases by date and I want to sum up those that occured
prior to 12/31/04, and 12/31/04 is the value in another cell. Can i have the
sumif refer to that cell for the "criteria"?
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro /...Add Replication to All Public Folders at Once
I have ~400 public folders, and we are mirgrating Exchange to a
dedicated server. I need to add replication for all those folders to
my new server, but I don't want to go through each individual folder
and add the replication for the new server. Is there a way I can add
the replication for all folders at once? Or is there a way I can
If your folders are nested, you only need to configure the top-level
folders. Then for each top-level folder, use All Tasks>Propagate Settings to
push the settings to the subfolders. You can select which settings to push.
Teresa Appelgat...I want more!
I need to extend a form that aleady has some 100 lines. For instance, one
column has the date, but only until tomorroq. How do I create more lines
based on the same formula?
I usually select the last row in the range and copy it down a few rows.
If you're using xl2003, you may want to look at Data|List.
And if you're using xl2007, this feature has transformed into Tables.
(Data tab on the ribbon|Data tools Group|What if Analysis|Data table)
> I need to extend a form that aleady has some 100 lines. For instance, one
> column has the da...How can I create a Sales form that can update both the Product and Sales Tables
Am creating a Product-Sales Database, and I would like the corresponding
Sales made in the Sale Table to be automatically deducted or to be reflected
in the Product Table. The product table contains all my stock and has a
relationship with the Sales Table. The Sale Table does not necessarily
include the Stock. How can I create possibly a Sales Form that will be used
as an entry point for all the products (stock) sold and automatically
register the sold products in the Sales Table and at the same time make the
required adjustments in the Products Table.
----------------------------------------...entering a # each row adds 1 to the previous cell. Turn off?
When entering numbers in my spreadsheets each row adds another number. i.e.,
2004 becomes 2005, then 2006. A telephone # becomes 811-6001, 6002, 6003.
How do I turn that off so when I pull the corner down to copy it stays the
You can right click and pull the corner and when you release the mouse
you'll get an option of copy cells or hold down ctrl and pull down with left
(No private emails please)
"dbog" <firstname.lastname@example.org> wrote in message
> When en...Combing Cell Values
Need some help with combing cell values. I know that =value(a1&b1) example.
Cell A1 = 1
Cell B1= 3
But if A1 has a text value such as ABC, I get an error on output. With text
and numeric, how do you combine?
try leaving out value
"JR" <email@example.com> wrote in message
> Need some help with combing cell values. I know that =value(a1&b1)
> Cell A1 = 1
> Cell B1= 3
> Ou...I don't want a page of the same label, I want one of each...
I can't find where to tell Pubisher that I want one of each label and not a
page of each label.
I'm using Publisher 2003 (Office 2003)
I see a post that says to enter "<<Next Record>>" but Publisher doesn't see
this as a field, just as text.
This can't be that hard, but I can't figure it out...
Any help would be appreciated.
I see that it prints correctly, but the print preview displayes it wrong....
I think I have it figured out...
"Kelvin" <firstname.lastname@example.org> wrote in message
news:OSpLwThUIHA.5508@TK2MSFTNGP04.phx....How do I add the Norton Anti-Spam toolbar in Outlook 2003?
I deleted the Norton Anti-Spam and Adopbe Acrobat folders from Outlook 2003
e-mail page and don't know how to get it back.
...extracting data from a cell
I have this data that stored into several cells and each sell holds a
combined 20 data entries in one cell seperated by a space. I was
wondering is there anyway to extract that data with out having to rekey
the numbers. We are talking about a combined 2000 line items if
individually entered. An example is to store numbers 1-100 in to one
Use Data | Text to Columns and use the space as a delimiter/separator.
"msam137" <email@example.com> wrote in message
>I have this data that stored into...Intercompany Sales
I'm using Great Plains, about to upgrade to 8.0 on SQL2000.
My department (parts dept) controls most of the inventory and therefore most
of the transactions going through great plains. Usually, I sell to
customers using SOP and all is fine.
I need to sell some parts to the sales department and the service
department. I've been using regular sales order processing to accomplish
this, however there are some obstacles I need to overcome.
(1) I need a price schedule that is the cost of the part. I'm having to
manually override all the prices which leads to human erro...how do I populate a cell with data from another worksheet,
I have two worksheets, both with similar data. Say columns are Acc No, Acc
Name and VAT number. Unfortunately the VAT number does not correspond on
each worksheet. How can I populate 1 worksheet with the VAT number so that
the data is collected on one worksheet? I have tried VLookup, but I'm not
really converant with it so would appreciate any help.
...Text want wrap in text box
I can't get the text to wrap in a text box, word wrap is set to true, I put
some text boxes on a sheet today and the text will not wrap, I did this
yesterday and it worked fine, I can copy the ones from yesterday and paste
them on a new sheet and they work, any ideas? I have rebooted but this did
not help. Using Excel 2000 (9.0.6926 SP3) Thanks Paul B
If you're referring to a Control Toolbat text box make sure that the
MultiLine property is True.
"Paul B" <firstname.lastname@example.org> wrote in message
news:%23ovLUkuLEHA.2456@TK2MSFTNGP12.phx.gbl......Go to cell based on input
In hoping someone can help
I have a cell (c16) the user will input a 1 or a zero into.
If its a 1 i want cell (F16) to be selected or if its a 0 cell (C17) to be
Cheers in Advance
Message posted via http://www.officekb.com
Put this code in the worksheet module.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$16" Then
Select Case Target.Value
Case Is = "0": Range("C17").Select
Case Is = "1": Range("F16").Select
End Se...Want to Add more Sub description Field
How I can add more sub description field like 1,2,3,4,5
You have only limit up to 3 fields in RMS 1,2,3 sub-description also you can
use the extended description and there is main description for the item. so
Altogether you have upto 5 description limit and I think that is enough. Let
me know if this won't fulfill your requirements else use the Item Notes for
Rate if like
"Saleem Suri" wrote:
> How I can add more sub description field like 1,2,3,4,5
> Saleem Suri
...Add 5 to data in text box!
What would I need for [On Click] in my Control Button that would add 5 to
[tbAdditionChargeAmount] each time I clicked it?
Thanks for any Help...........Bob
Private Sub MyCommandButton_Click()
Me!tbAdditionChargeAmount = Me!tbAdditionChargeAmount + 5
If that doesn't work, try:
Private Sub MyCommandButton_Click()
Me!tbAdditionChargeAmount = _
Val(Me!tbAdditionChargeAmount) + 5
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"Bob V" <email@example.com> wrote in message
news:OJaareyxHHA.4916@T...Add 2nd Y axis in XY scatter chart?
Is there any way to add a second Y axis and then plot data associated with
this axis in an XY scatter chart? If so, what are the steps?
Add your data to the chart then double click the new data series.
On the Axes tab of the format dialog chose Secondary axis.
Don Culp wrote:
> Is there any way to add a second Y axis and then plot data associated with
> this axis in an XY scatter chart? If so, what are the steps?
> Don Culp
Andy Pope, Microsoft MVP - Excel
...how do I add in a dinamic graph the total as a new series?
I want to add, in a dinamic graphic, a new series: the mean. Is it possible?
I need it to compare each series with the mean.
Thanks in advance. Regards,
The graph won't calculate the mean for you, so you'll need to calculate the
mean as a new series in your data sheet, and then include that series as a
new series in your graph.
"Guillermo Fuenzalida" <Guillermo Fuenzalida@discussions.microsoft.com>
wrote in message news:117FBACB-4DD2-41CC-864B-632666BE5CD5@microsoft.com...
>I want to add, in a dinamic graphic, a new ser...excel 97 #6
Why does excel put a : (colon) after the file name when
saving an excel document. ex. file.xls:2
This indicates that you have two (or more) windows open viewing the same
worksheet. Close all but one of them to restore Excel to its more normal
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"pz" <firstname.lastname@example.org> wrote in message
> Why does excel put a : (colon) after the file name when
> saving an excel document. ex. ...add ticker symbol money 2003
Set up investment accounts with mutual funds but did not
enter ticker symbols when I set them up. I need to go
back and add them but can't seem to find that option. Is
there an easy way to add them by looking them up or
entering them? Which screen?
On Sun, 27 Jul 2003 09:56:10 -0700, "s" <email@example.com> wrote:
>Set up investment accounts with mutual funds but did not
>enter ticker symbols when I set them up. I need to go
>back and add them but can't seem to find that option. Is
>there an easy way to add them by looking them up or
>e...I want to add a sound event when the cursor bumps left margin
I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
Put this in the sheet module:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
mvpearl omitthisword at verizon period net
"m...How to add a brand column in sales report?
I want to see detail on brands column on detail sales report.
How can dis be added?
It's not exactly pretty, but here's what we did:
I used SubDescription1 for brand, then ran a query to append ",
SubDescription1" to my Description field. You could also add SubDescription1
to the receipt.
You could probably use another query to populate SubDescription1 with the
SupplierName, but the two are not always the same.
The worst words in business:
"We''ve always done it that way"
Stop Fishing for eMail.
> I wan...