i am using following code to copy values from Source Workbook to Target
Workbook, its working fine.
information at source is in following format:
TargetWorkbook only requires "SCC", following funtion fulfill this requirement
How can i achive this goal using VBA, without entering formula in Worksheet.
s = "/SCC/4"
t = Split(s, "/")
--...want to apply function to numerous cells
Basically I want to divide a number of cells by a number in another cell. So
say, A1 through A10 by C3. However, I do not want to make the change
permanent, and I want to be able to see what the values would be if C3
changes. So apart from manually going thru and adding the = and /C3 is there
a way to map that = xC3 to the original cells. (I know its a circular
reference of sorts, but can i write a macro to perform that task for me.. or
is there some other way?)
and copy down to a10
"ExcelQuestion" ...Left function #3
I have a reference code that I wish to extract and paste into separate cells.
I know that if I use =LEFT(A1,1) will give me the first letter of my code.
If I use =LEFT(A1,2) it will put the first two letters in the same cell.
What I want is is the 2nd letter to be placed in a separte cell and the third
letter to be placed in a separate cell and so on.
Can anyone help please?
See Excel Help for
> I have a reference code that I wish to extract and paste into separate cells.
> I know that if I use =LEFT(A1,1) will give me...Using the kit function
We would like to create some kits using our inventory on
hand. How would we create them and have the individual
items depleted from stock and go to these kits. We need
to be able to know when to order more items to create the
kits when they are getting low.
Go to Database -> Items -> New Item -> Standard
then change item type to Kit, then click on Kit tab and add the items you
need, it will be depleted from inventory.
Click on attributes and set the re-order point and re-stock level for the
items, create a purchase order weekly or daily and select re-order point
method to cr...Excel if function
I do not want to calculate minus in my totals so how can I use the sumif
function with non consequent cells.
you may provide some more info about your data layout. Maybe you mean
"kim" <email@example.com> schrieb im Newsbeitrag
> I do not want to calculate minus in my totals so how can I use the
> function with non consequent cells.
...need a function to repeat a process
I have a large list of assessments for a school. Each assessment ha
five levels and a count of students for each level - like so:
lvl 1 9
lvl 2 13
lvl 3 24
lvl 4 7
lvl 5 1
lvl 1 7 12% =M12/$M$17
lvl 2 11 19% =M13/$M$17
lvl 3 29 50% =M14/$M$17
lvl 4 9 16% =M15/$M$17
lvl 5 2 3% =M16/$M$17
for each assessment, I need to total the counts, then determine th
percentage of each count. Easy to do for one but a pain to for th
whole school. If I could write a single function that used ove
again it would save me a ton of time.
Thanks in...Nesting more than 7 IF functions
I have a list with over 20,000 rows in it. Each cell in column D has a
number between 1 and 200,000. I would like to set up a formula in
column E that will show a letter based on what range the number is in.
For example, if the number is between 1 and 500, show "A", if it is
between 501 and 1,000, show "B". If there were only 7 number ranges I
would use a nested if:
and so on...
The problem is that I have 13 number ranges that I need to create codes
for. Any tips?
For ...Public Folder tree
We have some public folder trees that are getting 5-10 levels deep, as they
are by default matching our projects drive folder structure. I am just
wondering, is there a limit to how deep and wide a public folder matrix
can/should go? I can easily see a structure of 20 projects, each as many as a
hundred subfolders in a tree up to 10 levels deep, with literally thousands
of files in each project.
Am I courting disaster?
On Tue, 1 Nov 2005 11:02:09 -0800, Gordon Price
>We have some public folder trees that are getting...Complex formula change making m,e crazy
I have thsi formula...
myFormula = "=IF(ISERR(-TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN""," _
& "IF(--TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))<999," _
& "VALUE(TRIM(RIGHT(SUBSTITUTE(H2,""/""," _
& "REPT("" "",100)),100))),""UNKNOWN"...PostMessage() causes echo in Hook function
I have a program which installs a mouse hook. The hook procedure is in a
DLL. Under certain condition I post a WM_RBUTTONUP message. I've put some
trace messages in code. Now I'm wondering that my hook function is called
TWICE. When it's a *real* mouse message it's only called once. Can someone
tell what strange thing happens here? For simplicity I reduced the code to
From the APP:
LPARAM lp = MAKELPARAM (5, 5);
PostMessage (WM_RBUTTONUP, MK_CONTROL | MK_SHIFT, lp);
TRACE0 ("APP: PostMessage (WM_RB...USB Function driver for ActiveSync in wince5.0
I am writing Usb function driver with ActiveSync support in Wince5.0
for our hardware. I am facing something different problem. i.e., My
driver is working perfectly for one or two times, after that in will
get hang on middle of Bulk Out/In transfers. When I was checking the
debug messages, i found the following issues,
--> For Ex: When serial class driver initiates Bulk IN, in my driver,
IssueTransfer function gets called and I initialize the registers for
Bulk IN and writing data into data register. But in the middle of
initialization, i got one interrupt for Bulk OUT trans...Date Function?
I want a criteria that will return a list of records within a specified
month. The "Month" and the "Datepart" Function don't seem to be working for
me. Any advice?
"Caravatis" <Caravatis@discussions.microsoft.com> wrote in message
>I want a criteria that will return a list of records within a specified
> month. The "Month" and the "Datepart" Function don't seem to be working
> me. Any advice?
WHERE (((Month([Dat...Calling a function in a thread from a function in another thread
I have an application that uses two worker threads. I want to call a
function in one thread from a function in another thread. I used
PostMessage function but did not work properly. Alternately I dont have
a windows handler to be passed as an argument for SendMessage function.
Functions can be called from a thread, but it has no meaning to say a
function is in a thread.
Did you mean to say that you want to call a function from one thread at the
same time another thread in running that function? If so, you can certainly
do this. However, you must take certain steps...query is too complex error message
does anyone know if access 2007 has increased the capabilities of their queries? i have a query that was built in the 2003 version that keeps giving me the subject line error message. the query includes 7 fields that have a criteria requirements. it works for about a month and then just stops working. any help would be appreciated. thanks,andrea-- Andrea On Tue, 27 Mar 2007 18:13:51 -0700, Andrea <Andrea@discussions.microsoft.com>wrote:>the query criteria is as follows:>>([forms]![frmSearchByMultipleFunctions]![ThisValue5] >or([forms]![frmSearchByMultipleFunctions]![ThisVa...function symbols
What is the symbol for the inflation rate in excel?
There isn't a symbol. Are you thinking of the RATE function?
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Toni" <firstname.lastname@example.org> wrote in message
> What is the symbol for the inflation rate in excel?
one of my classes is on excel and we had a test with one
"22. Assume you are creating a worksheet to calculate
projected earnings. You expect to cr...Range of Factorial Function
For some analysis I am doing, I tried the following LOG(FACT(229)), and it
returned NUM!. I am wondering if 229 is too big a number to compute a
Factorial of ? If so, is there an upper limit (something like FACT function
can be applied for numbers <= 150) for the FACT function ?
Thanks in anticipation,
A little experimantation reveals that FACT(170) is the largest possible,
returning a value of 7.2574E+306.
"Rushi" <Rushi@discussions.microsoft.com> wrote in message
...Find function broken good
My Find function in Excel 2000 has stopped working
properly. It fails to find text that is right there. I
have experienced this issue before but closing Excel or
rebooting used to fix it. Now it doesn't. I cannot ask my
desktop guy to reinstall Office for me again; he's done
it twice in the last three months and it did not resolve
the issues for which I was asking for that. Is there
possibly a DLL or other file in which the Find function
resides, or on which it depends, that might be corrupted,
which I could get from another user's machine and copy it
over mine? ...Older "paste" function not available in 2003?
In some accounting programs, negative numbers have the
sign to the right. In Excel 2000 you could paste the
number and Excel would recognize it as negative, however,
this no longer works in Excel 2003. Is there a way to
correct this without using macros or formulas?
try using 'Data - Text to columns'
> In some accounting programs, negative numbers have the
> sign to the right. In Excel 2000 you could paste the
> number and Excel would recognize it as negative, however,
> this no longer works in Excel 2003. I...now function in a form
On a form in Access 2003, I created an unbound control and inserted the
The date and time is displayed. We do not want the time, just the date so I
selected the ShortDate format in the Properties.
Works fine, unless someone clicks the control, in which case the time
reappears. The form must closed and reopened to remove the time.
Can anyone explain this and suggest a work around.
"Marsh" <Marsh@discussions.microsoft.com> wrote in message
> On a form in Access 2003, I created an u...Printing Complex Workbooks
I am wondering if anyone has experienced this issue. Some
of my users have created very complex workbooks, with
different page orientations, formulas, colors and
different page sizes. When these documents are printed
(NDPS), Excel crashes. This only happens when the entire
workbook is printed. Not the active page.
The only solution is to use an older version of the Novell
print driver - NDPPNT.DLL.
Netware 5.1 SP6
Novell Client 4.90
HP PCL 5E (latest firmware on printers, latest version of
PCL 5E driver)
Novell's stance is if pr...Nz Function (?)
I have a mainform with a subform.
The subform is based in Q_SO.
The Q_SO has >=20 in Age column.
The same subform has another a textbox to show us age number.
Work fine and only show data if Age >=20.
The mainform has a textbox to show age number too.
But this textbox if don't show data in subform because Age<20, show #Error.
How is possible to resolve this, please.
Tnahks in advance.
You may be able to solve the problem with an expression like this:
=IIf([Sub1].[Form].RecordsetClone.RecordCount = 0, Null,
Access 2007 will not be able...Function to return a number of fixed length
I seem to recall (or maybe dreamed of) a function that reterns a
number to a fixed length. For example, if the number in question is
25 and the required length is 4, then the output of the function would
I realise this can be achieved with cell formatting, but I required
this in a function if possible.
<email@example.com> wrote in message
> I seem to recall (or maybe dreamed of)...Sum Indirect function through multiple sheets
I have been looking through Googgle for a solution but have yet to find it.
I am trying to replicate the following 3 dimentional sum formula using the
Suppose I have the following (without the double quotes):
in cell C1 I have the label "START"
in cell D1, I have the lable "END"
in cell E1 I have "A1"
in cell F1 I have "A5"
These are some of examples that I tried in cell B1
=SUM(INDIRECT("'"&C1&":"&D1&"'!"...Using complex formula in Diagram,AutoShape,WordArt,Organization Ch
Download and free try AddinTools Create from http://www.addintools.com
Make you using formulas and cell reference in Excel objects: diagram,
autoshape, wordart, and organization chart. To get thousands of Diagrams,
AutoShapes, WordArts, Organization Charts, Charts, Reports, Tabs, Cards, and
Forms that contain different values in several minutes! The quantity of
results that you can produce depends on the volume of data that saved in
Fully Utilize The Data In Workbooks. The data in results may source from the
same worksheet, and may also source from one or more workbooks and...need help..Simple, compound, complex, compound-complex examples
Need to write a paragraph on the four sentence types...Just need to have an
example of each type....please someone help!! Thanks
On 30/05/2010 4:18 PM, Peggylynne wrote:
> Need to write a paragraph on the four sentence types...Just need to have an
> example of each type....please someone help!! Thanks
and some of the other sites that appear when you google for the subject
of your post.
Hope this helps,
Doug Robbins - Word MVP
Please reply to the newsgroup unless you want to obtain my services on a