auto archiving functions
just wanted to aks if there is any kinda of *_auto_*- fucntion that ca
archive a worksheet separatly wihout needing to save the acctual file.
like i have "book1" and i add an entry then print the sheet but i don
want to save it cuz its a template-like but i want to have a record o
it some where else with same date.
like "book1 05-10-2005", "book1 06-10-2005" and so on to be saved i
i know i can do this by "save-as" but then i must always give the fil
name over and over and i must choose where to save everytime
----...Calling Charles Allen--Crystal Calculate Checks Report
I tried e-mailing you, but the e-mail came back undeliverable.
I saw in a previous posting that you have a payroll Calculate Checks Crystal
report. Could I please have this? If you have it in version 9 of Crystal,
that would be wonderful.
I would appreciate it, Charles!
You can e-mail me at firstname.lastname@example.org.
Again, I would really appreciate it!
You have to make sure you take out the nospam part. I'll see what I can find.
Charles Allen, MVP
> Hi Charles:
> I tried e-mailing you, but the ...New, Reply Forward functions not enabled
I tried everything recommended by other users. I can't even disable add-ins
as administrator (message says can only b e disabled by administrator and I
am the only user and I am logged on as administrator).
I activated a trial version of Office 2007 Pro, and Oulook imported all my
AOL messages but I can't send a message or reply forward etc.. Microsoft says
they don't provide any phone support or live chat support. Without being able
to send a message on Outlook its like reading a book.
When those button are no...Better Multi-Bin functionality
Better Multi-Bin functionality. It seems it is just an afterthought. But
most reports (which I'm still looking for a PO receiving report alone) don't
include anything more then just the Site ID. Not to mention better multi-bin
sales allocations, and maybe bin ranking to allocate with.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft W...using a time format in a count function
I have a spreadsheet that has the following:
A B C
Start Time Run Day Run Time
11/14/09 12:20 AM Sat 12:20 AM
11/15/09 3:30 PM Sun 3:30PM
The cells are formatted as:
A= Date & Time
C=A2(cell reference with a time format)
My goal is to count how many times the event occurred on a particular day of
the week and count how many times it occurred during a time frame. EG Monday
between 5:00 AM & 8:00 AM
I have the count for the day...Excel Calculator always requires an = before a math function, can be turned off setting?
I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
I always have Excel running and it's also my calculator. I never use use a
The answer to your question is no.
The equal sign tells Excel that you're entering a formula that needs to be
You can use a plus sign (+) instead of the equal sign (=) if you alwa...LookUp Function #5
Trying to use the above to insert an amount which will depend on the value in
i.e. in A1 is the price and in A2 I need the figure which is dependant on
the amount in A1. If A1 is less than 125000 A2 will be 0; between 125001 and
250000 the figure in A2 will be 1% of A1; between 250001 and 500000 the
figure in A2 will be 3% of A1 etc.
Similar problem with another cell where I need to lookup an amount from a
table i.e. if A1 is between 2 amounts the figure in A3 will be a sum which is
set out in a table.
Any help would be much appreciated.
Set up a small table like this so...vlookup / len function combined
I have many vlookups referencing cell A1/2/3.....with the text: "firstname".
I now need to add to these cells: "last name".
If I add this text, the vlookups search other data tables for "firstname
lastname" and return errors. How can I amend the referenced cells
(A1/2/3...) so that the vlookups only use "firstname" and disregard the added
change the vlookup(A1,myTable,Column,range_lookup) to
assuming you have all cells as
"jamesg-f...Absolute address for Indirect function
I want to make the reference in indirect function absolute because Im
copying this function to lots of successive row.
For ex. in F3 I have the formula --> =IF(ISERROR(VLOOKUP($D3,INDIRECT("'Raw
Now I need to copy this formula to F4 , F5 and depending on the data range
(which would change from one time to another) I will need to paste it down
My only problem is when I paste it down using autofill then the part -->
INDIRECT(&qu...Displaying international character set in CEdit and CListBox
How do I get strings with multiple languages (let's say a mix of
english, russian, japanese characters) to display in a Unicode enabled
application (MFC42U.dll). I read data from file that is utf8, convert
them to WCHAR and want to display resulting strings. CEdit and
CListbox controls have Arial MS Unicode font selected into them that
contains all the characters. The WCHAR strings have correct
information as I can check that in debugger, however when displayed in
controls, english is fine but all else is displayed with "ANSI"
equivalents (read: "gibberish") instead of ...Using user-defined functions in cells
What is the correct way to define a function that can be plugged
into any spreadsheet cell as a formula??
I defined a function as follows:
Public Function DoMyStuff ()
importantData = Sheet1.Range("A1").Value
importantData = importantData * 10
DoMyStuff = importantData ' Return a value
I then plugged my function into cell "B1" as follows:
Okay, now I noticed that when anybody edits the
contents of cell "A1" that my "DoMyStuff" is not getting
called ag...how to draw trend lines through only certain data points
i need to make a scatterplot with trendlines that only go through some
of my data. then i need a second trend line for the second part of my
data. any ideas on how can i do this? thanks.
Split the data into two series, and add a trendline to each.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"akh2103" <email@example.com> wrote in message
> hello all--
> i need to make a scatterplot with trendl...excel function to call solver (VBA Macro)
I want to know how to have a function call solver. Without any user
prompts or "alt + key". I just want a cell to contain [
=Solver(A1,3,0,B2) ] and be able to copy and paste this so the next
row is [ =Solver(A2,3,0,B2) ] I don't really care what the return
value is for the function. I just want it to set A1 to 0 by changing
B1. I have seen a bunch of people ask this question but have found no
answers? Can you even do this with excel?
If I understand your question well, you want to change a cell from within a
That is not possible. A functi...Search function (text or numerical)
Just trying to figure out how to implement a search function, as
sheet1 contains all the data to be searched;
one cell in this sheet contains "BMS-1865-1701-CZ05"
How can I search for this data, based on partial search criteria ? for
example my criteria would be : "1701-CZ"
I really need to use excel on this one...
marciac's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36151
View this thread: http://www.excelforum.com/sho...MS CRM SDK call
We are having MS CRM 3.0 (Roll up 2), we get Upate lot many errors "Generic
SQL error." while updating Incident entity in crm using CRM SDK.
When checked the Trace files we see following errors, it says that query to
p_GrantInheritedAccess is getting failed.
[2009-05-12 10:07:17.882] Process:w3wp |Thread:4556 |Category:
Unmanaged.Platform |User: PlatformUser |Level: Error |
c:\bt\876\src\platform\include\omcommon\dataaccess.inl Line: 825
>Call to COleRecordSet::Open() failed. Query = p_GrantInheritedAccess ?, ?, ...Multiple If functions
What is the best way to put multiple if function's is single cell. I am trying to say is if(c5>=1,1,0),if(c5<=18,1,0),if(c5>=19,2,0),if(c5<=48,2,0). So if a value of c5 is between 1 and 18 enter a one in the deisgnated cell, but if c5 is between 19 and 48 then enter 2
In the second example you don't bang into the limit
of 7 nested IF-functions.
Followup to newsgroup only please.
"Mark" <a...how do I create an icon for frequently used functions ?
for example: paste value etc.
...Use a IPU driver function inside a stream driver
I'm working on Windows CE 5.0 and Freescale BSP iMX31.
I have developed a new stream driver and now I want to add a new IOCTL code
to execute an action.
With this IOCTL code, inside the function XXX_IOControl, I want to call a
function that resides in another dll (display driver IPU).
What's the better way to do it ? How can I modify the sources file to use
thi display driver ?
Did you consider implementing the wished specificities in
DDIPU::DrvEscape and 'triggering' them using ExtEscape?
I suppose that calling ExtEscape from a de...want a drop-down CListBox
I want a CListBox control works in drop-down way rather than in vertical
scroll bar. Is there a way to do that?
In another way, I don't want a CComboBox control allows input but only
allows selection of the items. How to do that?
Thanks a lot.
> I want a CListBox control works in drop-down way rather than in vertical
> scroll bar. Is there a way to do that?
What does this mean? What is a drop down listbox?
Use a combo box and just make it a Drop List in the properties rather than
Drop Down. That will do what you want.
"Y Xu" <firstname.lastname@example.org&g...Vlookup And Lookup Functions #2
Thanks very much -- that is exactly what I was looking for.
I believe you left out a '(' immediately before the 'MATCH'.
This 'strategy' will work for a column LOOKUP and for an arra
Chuckles123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1494
View this thread: http://www.excelforum.com/showthread.php?threadid=27806
Not exactly. I see an EXTRA right parenthesis at the end of the MATCH
function, before t...Why function generated results are not plotting correctly? #2
Is there a follow up question, or haven't you noticed the response?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Need Help on axis problem in a chart"
<NeedHelponaxisprobleminachart@discussions.microsoft.com> wrote in message
...Math drawing question
I have got a math/drawing question and as the question will show my math
knowledge is of toddler level...
I've got a line going from x1,y1 to x2,y2 then the user inputs an angle
and a length for a second line starting from x2,y2 going to x3,y3
But how do I calculate the value for x3,y3? I think I need to do
something with cosinus and sinus and my angle and length but I don't
Thanks in advance,
Peter Proost wrote:
> I've got a line going from x1,y1 to x2,y2 then the user inputs an
> angle and a length for a secon...Automatic recalculation of array functions
I have a range of an array entered (Ctrl+Shift+Enter) formula that is
calculated using a function in VBA.
The value of each cell depends on inputs from other worksheets. I find
that if I change these inputs, the array entered cells will not
automatically recalculate (I have the options set to automatic
recalculation). In fact, even if I hit F9 or go to Tools > Options >
Calculation > Calc Sheet nothing happens.
The only way to recalculate the cells is to re-highlight the range and
hit Ctrl+Shift+Enter again.
I can rewrite the function slightly so that a regular enter wil...A question about ShellExecute function
How to use ShellExecute function to open a html file as following:
- Open it in the same window if it is opening in browser (Internet
- Open it in new window if it has been not opened.
Please help me.
...more IF function
I just received help for my IF function question with the followin
What does <>mean in the formula, is it greater than or equal to zero
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
The <> comparison operator means 'not equal to'.