To many formulas??
I used this formula for an employee form
And I need three more, but when I ad one, it doesn't work... Are there
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Yes Excel is limited to 7 nested functions. To go around it create a user
http://www....What is the command to replace a cell's formula with it's value?
What is the command to strip a cell of it's formula, leaving the formula's
value? I believe it is F2 something...
On Sun, 17 Jul 2005 21:37:02 -0700, "Cindy"
>What is the command to strip a cell of it's formula, leaving the formula's
>value? I believe it is F2 something...
I always copy it, then go to Edit --> Paste Special and select Values
"Learning is a behavior that results from consequences."
Thank you! (Is there also an F2 command? It's been literally years sinc...forms 11-01-07
I have on hedear mask command button as a menu.css for webpages
I'd like to open a form depending on cmd button on the same body of the mask
Ist it possible?Like with the tab strips?
...Can a formula check for a certain value in a range? #2
I need a formula function to check if a named range contains a certain entry.
A formula similar to: IF(DATA!Dave='computer',d16,""), where DATA is the
worksheet and Dave is the named range. But, rather than '=' I need a
function that checks if the range 'contains' a single or a number of
'computer' entrys in the range. The quantity of entrys is unimportant.
The named range is a number of rows, of which the first column is merged to
contain the name of the person the rest of the data refers to. The data can
contain numbers, text or...Linq. Create. Need advice.
I have 3 Linq to SQL entities: Article, ArticleLocalized and Language.
Each Article can have one or more ArticleLocalized. And each
ArticleLocalized is associated to a Language:
public partial class Article : INotifyPropertyChanging,
private int _Id;
private System.DateTime _Created;
private EntitySet<ArticleLocalized> _ArticlesLocalized;
public partial class ArticleLocalized : INotifyPropertyChanging,
private int _Id;
private int _ArticleId;
private string _Conte...Pulling Data 04-01-10
I have a large range of data that I would like to pull information from based
on several factors. There may be more then one outcome. Is there anyway to
pull that information and put it in a table on a different worksheet?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Microsoft MVP Excel
SalesAid S...help about GetBitmapBits!
unsigned char *px = new unsigned char
Please, tell me the color format of the px above.
"twing" <firstname.lastname@example.org> wrote in message
> unsigned char *px = new unsigned char
> Please, tell me the color format of the px above.
It isn't possible to determine it from what you supplied. The ...HQ
If the HQ Server has a static non-routable IP addresses, either 10.x.x.x or
192.x.x.x, how can the client connect to that server to exchange worksheets?
Your remote clients will need some sort of access to the HQ LAN. There are
lots of ways... The cheapest (and slowest) would be a direct dial-in
connection. VPN over DSL/Cable is probably most common and most
cost-effective. A dedicated WAN would be ideal but is likely cost
For VPN access, you will need to get a static IP from your HQ ISP. The
static IP will be assigned to the router. You will be able to keep...Excel formula printing
I'm trying to balance two different worksheets. I want to print the formula
from one cell in Worksheet A so I can check it against Worksheet B. When I
follow all the directions it only prints 1/2 of the formula (it's a very long
Is there any way to get it all printed without doing a screen print?
An idea: click on the formula bar, highlight the entire formula, and
press CTRL-C to copy the formula into the clipboard. Then open MS Word
and press CTRL-V to paste. This will allow you to print the entire
As an alternative, if the formulas are _very_ similar and...sumif concatenate formula
I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:
1 - If there is a letter "A" in cell 1 or 2, then concatenate cells 1 and 2
in cell 3.
2 - If there is number in cell 1 and 2, then sum cells 1 and 2 in cell 3.
Thanks for your help.
On Wed, 17 Mar 2010 14:45:03 -0700, Robb27
>I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
>cell 3 that is based on what is in cells 1 and 2. Examp...Please Help Outlook error message Can't create file:
Outlook Proffesional 2003
Can't create file: GBXxA002.doc. Right-click the folder you want to create
the file in, and then click Properties on the shortcut menu to check your
permissions for the folder.
I'm triying to open an attachement Please Help
Thank you in advance
Andy <Andy@discussions.microsoft.com> wrote:
> Outlook Proffesional 2003
> Error message:
> Can't create file: GBXxA002.doc. Right-click the folder you want to
> create the file in, and then click Properties on the shortcut menu to
> check your permissions for the folder.
...Excel formula to increment the month by 2?
In an excel worksheet, in a cell I am having a day, say for example
03-May-2005 or 03-05-2005, In another cell
I have to increment only the month by 2 i.e from 03-May-2005 to
03-July-2005 using a formula.
What formula should I use?
maybe you can use the following formula:
"thirumalairajan" <email@example.com> д����Ϣ����:%23hG1yYhLGHA.2904@TK2MSFTNGP10.phx.gbl...
> Dear friends,
> In an excel worksheet, in a cell I am having a day, say for e...excel 2003 + macro help
Please tell me what i'm doing wrong, i want the entire excel document to
Call Application.OnTime(Now + TimeValue("00:00:15"),
You have the solution at your other post.
Neil Holden wrote:
> Please tell me what i'm doing wrong, i want the entire excel document to
> Call Application.OnTime(Now + TimeValue("00:00:15"),
Don't know what the Auto_Close is about but this works......formula #31
Need your help.
I have these coloumns:
Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed
Level GENDER LOCATION
I have two sheets one with Attrition details and one with Headcount details
(only difference between the two is that Headcount does not have Reason of
1. Tenure has this formula =(F2-E2)/365*12
2. The data is for the previous one year
3. I have monthly headcount and monthly attrition figures.
4. In the Headcount, I have put last date of the month as the DOL (Date of
leaving) so that I can get the exact headcount tenure.
5. Status me...Help modify this code please
someone kindly helped me to generate the following code, however i nee
it do a little extra to what it currently does.
PRIVATE SUB WORKSHEET_SELECTIONCHANGE(BYVAL TARGET AS EXCEL.RANGE)
IF TARGET.LOCKED = TRUE THEN
IF TARGET.COLUMN = 1 AND TARGET.ROW <= 19 THEN
ON ERROR GOTO DUMP
IF ERR.NUMBER = 1004 THEN
MSGBOX \"WRONG PASSWORD\"
i need the range to also include cells b12:b2
-----------------------------...I need to know if there is a template for my needs...
I'm trying to compile a scheduling program via Access/2000 (Yeah, I know
that's an old program....LOL. thanks for my employer's budgeting...LOL). I
trying to setup a scheduling process for teachers and students and be able to
print forms....Is there a template that you could suggest that I try and use?
I have OL2002-SP3 and two IMAP4 account, my problem it this :
I have account ACC1 as default account and account ACC2 as other one.
They have separated .PST files : ACC1.PST and ACC2.PST (it seems impossible
to have only 1 PST file for both)
I have built a simple rule to save outgoing msg in the SentMsg folder for
each account :
The rules like :
"After you sent a msg through account ACC1 copy the msg into ACC1->SentMsg
(the same for ACC2)
well it works, BUT ONLY FOR THE ACCOUNT I'M USING AS DEFAULT, for the other
one the rule does NOTHING (no copy, no e...Content type of '', but expected 'text/xml'
I am getting this error all over our CRM.
System.InvalidOperationException: Client found response content type of '',
but expected 'text/xml'.
Usually I reboot and it goes away. This time the reboot is not working
Thanks for your help!
...Macro help #8
Here is what I have:
data is in rows A3:R19
I need to copy and paste(Macro) this data to
The first available row is A3 Sheet4(Total)
The Sheet3(pcdata) will be updated daily
the macro needs to paste the data on Sheet4(Total) below the existing data,,
(next available row).
As I am quite a novice at excel. any help.. is very appreciated.
Regards Ron de Bruin
"Mike" <firstname.lastname@example.org> wrote in message news:rBKle.11597$Is4.5585@attbi_s21...
&g...Better color progression needed. . .
I am charting a 3D surface plot, but the colors provided in Excel (97) don't show a smooth progression eg light to dark or red to blue, and this gives a disjointed effect if the chart is reproduced in greyscale. Are there any sample charts out there where I can import better colors
XL is rather limited when it comes to color sophistication. It is
limited to the 56 colors in its palette, though, it is possible to
replace any of the 56 with others of your choice.
Your other option, I imagine, is to export the XL chart as a graphic
image into the image editor of your choice ...Import Help
I have a billing system I am developing for a client. They would like
to export the data from that system into their Dynamics GP system. The
purpose is to be able to generate invoices without having to re-enter
the information. I am trying to determine what the best method for
doing this is. Any help is greatly appreciated!
Thanks for the quick reply! I do not have any experience with Dynamics
GP. Unfortunately at this stage I haven't even seen the product.
The company is a non-profit agency that deals with developmentally
disabled people. They have very a limited budget. Is e-Co...Error message launching Dynamics GP 10
I get these messages, from one user only on a terminal server:
1. Dictionary Location ID: (then a blank box)
2. A workstation needs to be defined in your preference file
Again, this is just one of 68 users on one of 3 terminal servers.
To troubleshoot this issue further I will need to ask you some additional
1. Is this a new installation of the Client?
2. Have you installed any new software on this workstation?
3. Check the Dynamics.set file and review the locations it is pointing to
> I get t...printing formula version and values togheter
How can I print formulas and values togheter froma excel worksheet?
"Carlos" <Carlos@discussions.microsoft.com> wrote in message =
How can I print formulas and values togheter froma excel worksheet?
You could go with a John Walkenbach macro posted below which places all
formulas, values and addresses on a ...help!~!!!!
my motherboard took a dump, so I had to replace it, well
when I did that, I bought a new hd and reloaded my winxp
pro on it with office 2k, now I need to get my emails and
addys from the first hd, if I slave it, i can read all
the info, but if I make the old hd primary, it won't boot
with the new m/b. HELP!!! I really need my contacts and
if you can slave it, that should be all you need... just
copy the Outlook .pst file to the new HD and import the
data... you should not have need to make it the primary
again unless that was your intention... ...Excel sheet meltdown help!
Excel was working fine then for some unknown reason everytime I open up a
workbook the "edit toolbar" appears next to the highlighted cell. I cant turn
it off nor can I enter text into the highlighted cell without double clicking
it first. Any help would be most welcome
I don't know what the EDIT toolbar is, except in the Visual Basic Editor. If
you mean the Edit menu has gone awry, you should probably troubleshoot Excel
by renaming your *.xlb file: