I was windering if some one could provide me with a link to a tutorial for
what I am trying to do.
I have an aggregate table. This table has several groups and several
columns. The intersection of a group and column is an aggreate value such as
Sum function of a column value in that group.
Normally a Pivot table shows 1 aggregate value at the intersection of a
group and a column. What I want is:
To show more than one value at the intersection besides the aggregate value.
In other words, if a simple pivot table cell is:
Aggr(x,y) where aggr is an aggregate function such a...format based on data from another cell
I want the names in column B of my spread sheet to highlight either red or
yellow based on the value of the cell in column L, but with conditional
formatting you can only format based on the value of the cell you are
formatting, as far as i can tell.
conditional formatting can be used to do this,
select the column B cells that you want the formatting to be applied to,
ensure that the first selected cell is the first line visible at the top of
choose format / conditional formatting
where row 2 is the first row in the selected column an...I need to delete oldest record so that table only contains latest record 09-16-07
I have a table called DDPayments which contains 4 fields: PaymentID,
DDID, BankID and Date Paid. I need a query that will delete all
records, so the rows will only contain the most recent Date when a
I currently have the following in the table:
ROW 1 - PaymentID: 1 DDID: 9 BankID: 1 Date Paid: 13/08/07
ROW 2 - PaymentID: 1 DDID: 9 BankID: 1 Date Paid: 13/09/07
ROW 3 - PaymentID: 1 DDID: 26 BankID: 1 Date Paid: 10/08/07
ROW 4 - PaymentID: 1 DDID: 26 BankID: 1 Date Paid: 13/09/07
ROW 5 - PaymentID: 1 DDID: 6 BankID: 1 Date Paid: 13/08/07
(This table i...range specified by the value in another cell
I have the following problem:
I have let say 100 numbers in column A, and a number
n<100 in cell B1. I want to have the sum of the first
n numbers in column A, so I would need to specifiy the range
A1:An, but I need this independently of the actual value of n.
I have tried A1:A(B1) with but it doesn't work.
So has somebody any idea
Message posted from http://www.ExcelForum.com
2 ways for it
1. Use the formula
2. Create a named range
The formula will be
(When s...Pinging Ed Bennett for help on this one
You were kind enough to help me create the following vba code for publisher
2k3 several month ago. I recently had to install a new m/b and all of my
apps and for some reason this code _doesn't seem_ to work anymore. I say
that because no longer do the toolbar buttons get created. I suspect it has
something to do with my security. I self certified the original code and I
am thinking maybe my certification is invalid. Would the best way to proceed
be delete the vba code, recreate it (i.e. copy/paste back) and self cert
again to get it to work? Or am I missing something basic here...Terminating another MFC app
I would like to terminate an MFC app from another MFC app, but do so nicely.
Basically, I would like app 1 to post a WM_QUIT message to app 2.
TerminateProcess seems to extreme. Any thoughts on how I can do this?
"Ken" <Ken@discussions.microsoft.com> wrote in message
|I would like to terminate an MFC app from another MFC app, but do so
| Basically, I would like app 1 to post a WM_QUIT message to app 2.
| TerminateProcess seems to extreme. Any thoughts on how I can do this?
CWnd* pPrevApp = CWnd:...Report using RWOP (owner permissions on secured table)
I have a database that links to some tables where the permissions have been
removed for everyone except the owner. I am trying to make a report access
the data using owner's permissions.
In the recordsource I have the following:
SELECT Classes.Class FROM Classes WITH OWNERACCESS OPTION;
This isn't working. What am I missing?
I have about 35 reports that I would like to convert to this format so that
my tables are more secure.
...auto generate emails from data stored in excel spreadsheet
Is there a way in excel to automatically generate an
email which is stored in a worksheet either using excel
macros or in conjuction with outlook.
thanks in advance.
Maybe this one
Regards Ron de Bruin
"MarkK" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Is there a way in excel to automatically generate an
> email which is stored in a worksheet either us...Merging data from two worksheets
I have two worksheets with lists on them. On worksheet A there are items we
use, and charge code (which correspond to individual items); but there is no
RMS code (a specific code we use for our system). On worksheet B there is a
larger list of items, many of which are also on worksheet A. Worksheet B has
a column with the same charge codes as are used in worksheet A, but worksheet
B has the corresponding RMS codes.
Item RMS Charge Code
Stick (blank) 12345
Ball (blank) 54321
Bases (blank) 21543
Item RMS Charge...How set many row heighths = height of another row
Is there a nifty way to use paste special to copy a row and then select a
bunch of other rows and set all of these selected row to the same height as
the copied row?
I need to do this for several rows on several sheets and first getting the
height # of the source row, then setting heights of target row numerically is
I appreciate your help, -John
"John" <John@discussions.microsoft.com> wrote in message
> Is there a nifty way to use paste special to copy a row and then select a
> bunch o...Copy an email to a saved folder
I get some emails and want to save them immediatly to the "saved" while still
having a copy in the " inbox" to respond to but there is no "copy to folder"
button in the drop down list, such as there is in Outlook express. Can I get
one in there somehow. If I save it to a word file I then cannot respond to it.
On Tue, 17 May 2005 11:57:18 -0700, miltdp
>I get some emails and want to save them immediatly to the "saved" while still
>having a copy in the " inbox" to respond to but there is...Extracting XML data to be used in XSLT HTML output
I have done small level Xml stuff and am just now starting to understand
some of the plumbing involved. I've done a lot of .NET programming for SQL
Server, but little for Xml data stores.
I am currently just interested in using the .xsl file that I have being
applied to a source .xml file through ASP classic. Here's what I have:
<?xml version="1.0" ?>
<xsl:output meth...Unable to Access Mailbox Stores on one Server
I am the Exchange Administrator (MS Exchange 2003) with a medium sized
company. We have two back-end and two front-end servers and I use Exchange
2003 System Manager to perform a number of administrative tasks throughout
the day. I run the utility on a Windows XP Professional computer.
I can get into the Storage Groups and underling Mailbox Stores on three of
the four servers from this setup, but one of the back-end servers shows the
mailbox stores with red down arrows which indicated that the stores are
off-line (Yes Store.exe is running on the server). But if I log into the ...save as html
when i save a file as html it can not be filled in
is there a way to save it as html and also be able to fill it in?
...Finding differences between two tables
Who can help me?
I have 2 tables with mainly the same names. I want to find the names that
are not in both list.
I managed to do it the following way, but I think that it can be done
Advances filter: as criterium range one of the 2 tables.
With Edit - Go To - I highlighted the visible cells and coloured them.
Removed the filter
With Edit - Find - Format - I highlighted the noncoloured cells.
Here are two ways you can do that but I wouldn't say they are much easier
than what you did. Put both lists on the same sheet in the same column, one
under the other,...Look up tables vs. value fields via combo box on form
I have tables such as t_WeatherData in which I have fields such as
Temperature, WindSpeed, WindDirection. The WindSpeed and WindDirection
fields each have a lookup table with an ID (primary key/autonumber) and a
field that holds a category ("N", "NE", "NW", "W", etc., or "< 5 mph", "5-10
mph", etc.). As I have it, the look up tables merely serve to populate a
combo box on the data entry form...
OR, is creating a combo box with a value list sufficient?
What should be the factors in my decision on when to use a look...overflow data
When i input data into a cell, can i fix it so it doesn't
overflow the adjacent but empty cell? Thanks.
You could enter a space character in the adjacent cell, so it appears
empty, but will stop the overflow.
> When i input data into a cell, can i fix it so it doesn't
> overflow the adjacent but empty cell? Thanks.
Excel FAQ, Tips & Book List
thanks, Genius! :-)
>You could enter a space character in the adjacent cell,
so it appears
>empty, but will ...external data not in a table
I have a worksheet originally created in excel2003 that gets external
data from a db2 database. After migrating to excel2007 the external
data in the worksheet is not in a table (clicking on a result cell
does not make Table Tools appear). When creating a new database
query I find that the results always get put in table. I don't want
the results in a table. How do I make the results of a new query NOT
be a table? And I don't want to break the link to the database since
I update the results periodically.
...How to copy a Macro to another PC
How can I find and copy an Excel macro to another PC. As I recall the one I
created also created a file called Personal.xls that automatically opens up.
Not sure if this is the only file that needs to be copied? Also, where does
it get copied to? What location? Same as original PC?
Personal.xls is automatically opened (if it exists) but is hidden; use
Widows | Unhide to see if you have one. Generally it is kept in the XLSTART
folder; find it with a search.
However, some people have Excel open other files automatically; Use Tools |
Options and look on the General tab to see ...How to Use Data Migration Pack
i downloaded the DMF from Microsoft.com,
i read the documents but i couldn't understand that,
My exact Requirement is, i have to import 18000 Records to Product
what i have to do now, please give me guidelines to import Records,
On Sep 8, 7:04 am, mukathangadu...@gmail.com wrote:
> Hi All,
> i downloaded the DMF from Microsoft.com,
> i read the documents but i couldn't understand that,
> My exact Requirement is, i have to import 18000 Records to Product
> what i have to do now, please give me guidelines to import Reco...Lost file
My daughter turned off my computer before I could
name/save a file in Excel. Will a temp version of it
...Save As Disappeared
I can no longer access the Save As option for any of my
spreadsheets. Any ideas?
You can reset your menubar to default
Right click on the menubar and choose customize
Under Toolbars select the worksheet menubar
and click on reset on the right
You lost all the things you changed to the menubar
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Steve" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I can no longer access the Save As option for any of my
> spreadsheets. Any...Saving attached files in Outlook
What is OLK8 and what is it supposed to do?
Outlook wants to save attached files to a folder called
OLK8. When I want to go find the files I can't find the
folder OLK8 even thought the save path indicated that it
was in "local settings". It doesn't appear to be a hidden
file. Why is OLK8 so hard to find when it is the default
Outlook save location? The MS KB is (per usual) no help.
It is a temporary file for storing attachments. If you are using Windows
2000 or XP, try turning on hidden and system folders and then go look again.
Milly Staples [MVP - Outl...Exporting One File to Two Others
Here's the situation - hopefully someone can answer my question or come up
with a better idea.
My daughter owns a used book store and has and inventory of over 10,000
My thoughts were to have three different files for serch purposes. ie
Title, Auther, Subjuct Matter and add a Referance Number to each book. This
way if a customer askes for a book, the serch would be easy.
The problem lies in the sales. When a customer purchases a book, she would
write down the Referance Number on a sheet of paper then at the end of the
day, enter all the days Reference Number into the fi...Ignore a Blank Data Series in the Legend
I'm creating Pie Charts based on data from 10 data series fields. Some of
the data fields are blank, and so I've managed to create data labels that
only show on the Pie Chart if there is a value (otherwise the Chart was too
hard to read due to lots of blank labels).
However, if I show the Legend, the blank data series field still appear, so
I have say, 4 labels with the correct data series names but 6 which are
blank. Can I make the Legend ignore blank fields, and just show the 4 that
You can manually remove individual legend entries. Click on the lege...