need help with SUMPRODUCT
Mon, 25 Aug 2008 05:08:03 -0700
Hello,
I can use constants in SUMPRODUCT function, for example
SUMPRODUCT(...*(C100:C1000={"apples", "oranges'})*...), but I have troubles
when I am trying to use SUMPRODUCT with values from particular cells, for
example SUMPRODUCT(...*(C100:C1000={A1, A2})*...). Please help me with a
sysntacts I shoud us ...
|
VB Code to List all Sheets and Charts in a Workbook
Mon, 25 Aug 2008 03:38:01 -0700
I have a large workbook, which needs a 'Summary Sheet' listing all the tabs
in the sheet at the beginning. The tab names change quite often, and new ones
are added; so, using VB, how do I list all the tab names in order in a range
within the first sheet? Some of the sheets are actually Charts within their
ow ...
|
Basis question about Group/Ungroup
Mon, 25 Aug 2008 02:52:01 -0700
Hi all:
My dev environmnet: office 2007 ,VS 2007, c#.
I want to group rows (say from row 2 to row 7) in a worksheet, how can i do.
Also, how could i know group by rows or by columns ?
Consider i am a novice to excel, please give me information as deatil as
possible.
Useful links are welcome.
thanks in ad ...
|
Hyperlinks on Ribbon/Office 2007
Mon, 25 Aug 2008 11:36:43 +0200
Sorry for the reposting/cross-posting (as the
*office.developer.officedev.other-NG seams to be desolate?)
--------
Dear Office 2007-friends!
In former versions of Office symbols on a commandbar could be used in
three ways:
(1) linked to an integrated command (via ID),
(2) linked with "OnAction" to a macr ...
|
How to update Excel file using MFC?
Mon, 25 Aug 2008 02:36:02 -0700
I use Visual C++ MFC 4.2.
I need to update MS Excel file from my application.
Features that I need to do are:
1. Centering the text alignment
2. Creating the cell border
3. Changing the text color
And the other features is standard, like reading the cell content and update
it.
How to do those advance ...
|
Range names vs Sheet name
Mon, 25 Aug 2008 02:32:02 -0700
I'm suppliying various branches a standard workbook for stock control.
Currently the sheets are name Stock1, Stock2 etc to Stock150. The user will
be able to change the sheetname to a more descriptive name (stockitem name).
A macro will sort the sheet names in alphabetically order which will be
easier to sel ...
|
Match the HEADINGS
Mon, 25 Aug 2008 01:00:02 -0700
Hi
Everyday i recv many files(workbookS) from clients, i need to paste each
excel files to our master file.
So, whenever i open any of the client file(workbook2) and master file
(workbook1) the macro should match the heading and copy the data from
client file , i do't need macro to open the file becau ...
|
|
|
How to setup gutter + double sided print for Excel?
Sun, 24 Aug 2008 23:34:01 -0700
Hey
Could anyone kindly help me with double sided print with a gutter in left
with Excel?
It seems the function is not available in Excel.
Anyone has related macro codes?
Thanks a lot!!
...
|
INT to ROUNDUP
Mon, 25 Aug 2008 15:08:28 +1000
Hello all, I would like some assistance.
Using Excel 2007 on Vista
Confused with RoudUp and Round in procedure
Some thing to do with remainder didgets. How do I name them as long or
whatever
Public Sub CashFlow()
Const dCashCommission As Double = 0.05
Const dCashTake As Double = 0.2
...
|
Adding button in sheet & assigning it to a macro
Sun, 24 Aug 2008 20:38:01 -0700
I am wanting to add a single clickable button inside of a cell on a worksheet
that automatically runs a macro. I have never created a button inside a
sheet and am still new to VBA. What is the best way to go about this?
Here's the Macro
Sub CopyTrackStatsValuesforSorting()
'
'COPIES THE Track Stats WORK ...
|
