I'm using one excel document with Data >- Filter >- Autofilter function. I'd
like to put autosum command but it doesn't work with autofilter's columns.
Have you try to use =subtotal(9,range)
"Dan" <dan_REMOVE_@ihson.com> ���g��l��s�D:O0fqZzW0GHA.3568@TK2MSFTNGP03.phx.gbl...
> I'm using one excel document with Data >- Filter >- Autofilter function.
> I'd like to put autosum command but it doesn't work with autofilter's
> Please help.
"bobocat" <bobo.c...Running Sum
How do I calculate a running total for specific functions? My example is as
A B C D
1 Function: Email Phone Email Faxing Prepping
2 Start Time: 4:25 PM 6:15 AM 6:30 AM 7:05 AM 7:50 AM
3 End Time: 5:05 PM 6:25 AM 6:35 AM 7:30 AM 8:00 AM
4 Total Time(min): 40 10 5 25 10
In another Cell, for example B6, I want to total up the total time of all
Email (B4+D4), Phone, Faxing, Prepping etc. The user is picking from a ...Summing two columns
I have values in two columns, A and B in a single worksheet. I want to multiply values in column A with the inverse order of values in column B and add them and put the results in column C. For example at C1, I want to have A1*B1, at C2, A2*B1+A1*B1, at C3, A3*B1+A2*B2+A1*B3 and at C4, A4*B1+A3*B2+A2*B3+A1*B4, etc. How can I accomplish this job with SUMPRODUCT or VBA and fill that column automatically. Any help is welcome.
Here is an inelegant subroutine
Option Base 1
Function doit(N, rangeA As Range, rangeB As Range)
Dim tempA(10), tempB(10)
j = 1
For Each cell In rang...Gridview control to XML only want one column ???
This produces XML with all the columns in the gridview.
Dim View As DataView
Dim RatePlans As DataTable = View.ToTable()
Dim ds As New DataSet
Dim xdoc As New XmlDocument
What if I only wanted a single column called "RatePlanId" ?
What if I wanted the root and tags to have specific names like
<ratePlan> <rateplanid>whatever </rateplanid> </rateplan>
right now tags say s...Referencing a cell from another worksheet
I am in cell F5 of worksheet "January" and am trying to get it to display
what is in cell B1 of worksheet "Sheet1" within the same workbook. For some
reason it won't show the value, it just shows me the formula i've typed in. I
='Sheet1'!B1 (which i have in another document and it's working fine)
Occasionally Excel can be stubborn that way. Try an alternative method of
entering the formula. Within teh cell where the formula is type the "=" then
navigate to the worksheet and cell ...drop down box leading to another drop down box
I have a cell containing a drop down box with three options. Can i design my
worksheet so that when one option is selected a drop down box in the
neighbouring cell appears with a number of options in it?
Each of the original 3 options in the first drop down box needs to lead to a
different list in the second drop down box, though the options can be
Any help would be much appreciated.
stumakker, have a look here and see if this will work for you,
Always backup your data before trying something new
Please post any r...How does one restrict the number of times a sales invoice can be returned
How do I restrict the number of times my cashiers can return a sales
invoice. Currently, RMS has no limit to the number of times a sales invoice
can be returned.
think the only way to do this is by a personalized add-on, that would count
the number of times an sales invoice have been returned. When the count will
pass the preconfigured limit-number, this add-on could block the continuation
of the return process.
You need a Partner to develop this for You, don't think it's too dificult.
Try to find a Microsoft RMS Partner in your area an...Transposing information from one sheet of a workbook to another
I'm trying to transpose information (names) from one worksheet to another
within the same workbook. I can do it on the same worksheet by using the =
sign then clicking on the box that i want to transpose. However when I
attempt to do this in another worksheet I get an error that says #value. Any
select the range you need, click copy, select the first cell on the other
workbook you want the info in, click edit/paste special and check the
transpose box. then ESC to clear the copy mode.
> I'm trying to transpose information (names) f...Maintain PO Line item number sequence when one is deleted.
Once a PO is printed (released), if a line item is deleted, all subsequent
line item numbers are resequenced. I would prefer they are not resequenced to
maintain accurate history and to all me to tell the vendor that line item 13
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 Web-based Newsreader and then
click "I Agree"...How does one CENTER images, text boxes etc., on a PAGE?
I have not been able to find the feature that centers all images or selected images, taxt boxes, etc., on a page. Secondly, I have noticed that if the content of one page are copied on to another page, the copied sontent is not placed in the exactly same location as the copied material. W#hy does this happen and how can it be fixed? I am using Publisher 2003 and 2002. The problem seems to related to both versions.
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Stevk <email@example.com>...
> I have not been able to find the feature that centers all images ...Automate another app
I have been programming in VB (classic) for many years and am quite
familiar with how I would accomplish this in that enviornment.
However I just started using C# and have no clue. For starters in VB
I would start the other application by calling the Shell function.
Then to actually control the other app I would first locate the window
handle for controls I wanted to interact with using Win32 APIs which
allow me to retrieve the hWnd for a window given its ControlID
(gathered from Spy++). I would then use the SendMessage API (with the
appropriate message constant) to enter text in edi...Two Forms One Record
Hi! Im a beginner in access. I have two forms (BirthCertificate and
BirthCertificate2) that share one recordset(?) --> one row in a table . I
separated them due to many fields. I have a command button that opens the
other form but I want it to open on same page as the first page on my first
form -- like continuing to type on a table..
The code should read something like (untested):
DoCmd.OpenForm "Your second form" ,,, "PrimaryKey = " & Me.txtPK
where "Your second form" is the name of the second form
PrimaryKey is the name of that key in your table
txtP...Rank items, select one start date, have remaining dates follow based on rank
I have a list of projects. I have one start date. Each project has a
varying amount of time to complete. I want the user to rank the
projects based on importance (example when it will ship) and then,
based on the individual times required to complete the rest of the
projects, excel will automatically generate start and complete dates
for the remaining projects. Need to know how to do this.
rob normerica's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26316
View this t...getting data from one sheet to another
I am working on a labor chart. The first sheet has the names and day of the
week. I have them formatted to just put in the number of hours and it
There are 4 different job descriptions and at the bottom of each day, it
totals the dollars spent for labor on that day.
My second sheet has sales and will divide the cost of labor by sales and
give me a percentage.
On the second page, how can I get the total dollars in labor for each
catagory from sheet one to a certain cell on sheet 2 without manually
entering it. I know it can be done as I have seen it before
Assuming the da...Copying daily data from one tab to a weekly summary table
I have been working on this for a little while now and can't seem to grasp
the right formula to use. I have columns of data sorted by name to be
tracked daily. I need to then give my boss the information so she can not
only see it daily and monthy which I have figured out - but wants to see
weekly as well and thats where im stumped.
The formula I am using to get the week number populated works great and is
What I need to do is get totals from "Table2" to "Table3" into a weekly
format instead of daily. So in esse...Modifier
We recently acquired Modifier and have successfully
modified acouple of forms (making fields required) and
have added some VBA code to another window.
Now I am attempting to modifiy another window,
specifically the Purchasing Invoice Entry window. However,
when I make this my current window and then go to Tools -
Customize - Modify Current Window, I get the following
message, "The Modifier is currently unavailable because
another user is editing resources in the Forms
Dictionary." I have tried it with other windows as the
current window and get the same message. Similarly, ...Merging Multiple Rows into One Row
I currently have a project of about 11,000 rows that essentially
should be about 3,300 rows.
the data is looks something like this:
Company Mon Tues Wed
I would like it to look like this:
Company Mon Tues Wed
ABC 24 32 16
Is there an easy way to merge the unneeded cells and make it one row
instead of three for the same company?
> I currently have a project of about 11,000 rows that essentially
> should be ab...Using a range in Sum Function
I have run across an oddity in Exel 2010 Trial Edition.
If I define a range to be cells c1, d1, f1 and g1 using the Name Manager and
then put the following in another cell:
=Sum(range name), the function returns the proper value.
BUT, each time I open the worksheet after just viewing it (not changing
anything), Excel asks me if I want to save the changes. I didn't make any
changes so why should it ask me that?
Is there a solution to this?
Do you have something in a header or footer that deals with current time or
MVP M...Problem with the Outlook interface on one client
We have problem with the outlook interface on one of our computers.
The user gets blank windows when he is going into a specific card in MS CRM
(like contact, account, task and so on) Lists work fine.
This problem occurs after he has been using Outlook for a while.
The problem never occur in the webinterface and if he restart outlook it
also works fine, but only for a while...
Does anyone have any idea?
Sounds like a strange problem.
I would try:
1. Clear the IE temp files
2. Repair the CRM Outlook Client and apply latest update rollup
Frank Lee, Microsoft Dynamics CRM MVP...another Exchange question ... two SMTP domains in one AD domain
I have a test environment with two standard edition Exchange 2003 servers in
one mixed mode Windows 2003 Active Directory domain. Each Exchange server
has its own SMTP domain -- say a.company.com for Exchange Server A and
b.company.com for Exchange Server B. The users are only going to use
Exchange Server A or B depending on their physical location in proximity to
the server. Exchange Server A and B are also domain controllers, where
Exchange Server A is the global catalog server.
When I add a user to AD, they get firstname.lastname@example.org and email@example.com
as email addresses. I can delete ...multiply one text box on report by a value
I have a report with some calculated fields that produce a sum of values in a
query this is achieved by =-DSum("[xxxxxx]","[anotherfieldxxx]") I need to
multiply this by another value(i.e. 20.00 dollars and can't get this to work
not sure why
> achieved by =-DSum("[xxxxxx]","[anotherfieldxxx]")
Your DSum expression does not look correct to me. What does the "[xxxxxx]"
part represent. It should be the name of a field. The next part,
"[anotherfieldxxx]", should be the name of a table or query (the Domain).
All domain aggr...More than one e-mail inbox
I've set-up my various e-mail accounts and would prefer the new messages
received by each to go their own e-mail inbox. I've set-up the inboxes and
the "pst" file but when I try to change where the incoming e-mail goes it
changes it for ALL my e-mail accounts. Is there any way around this? I've
assigned a different "pst" file to each inbox and that works but the area in
set-up where you choose which inbox incoming mail goes to just won't let me
assign different places - it just wants it all to go to my default inbox.
Does this make sense to anyone ...one computer to another
I have just purchased a new computer. How do I transfer
my old outlook files to the new computer? Running XP Home
Check this page for all you need to know:
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"firstname.lastname@example.org" <email@example.com> wrote in
> I have just purchased a ne...Summing within a Cell
I have some cells that look like this:
Is there a way to sum the dollar values while ignoring the text?
One way ..
Assuming source data in A2:A4
Put in say, A1:
Note that source data is assumed representative (as posted) throughout the
range to be summed, otherwise we'd get #VALUE!
"Frank Price" wrote:
> I have some cells that look like this:
> $10 red
> $4 Blue
> $1...sum across worksheets conditionally
I have about 50+ worksheets in a file that I need to sum. However, I only
want to sum some of the sheets if it meets a certain criteria. This criteria
is located in a separate worksheet in the file that lists each worksheet name
in one column and in the next column it list the type of worksheet. If a
worksheet is of a certain type I need the sum of those types.