Help: AutoFilter not 'hiding' data from other formulas
I'm using AutoFilter on a columns of personal data for which I've set
up other calculations (averages, percentiles, etc). I was hoping that
if I filtered, say, just for women, then the other calcualtions would
reflect only the women's data, but they still seem to reflect the whole
column of data, including data that's hidden by AutoFilter. Is there
any easy way to fix this? Thanks!
Do you mean that you have some SUM( ... ) formulae which do not change
to reflect only the displayed values? If so, you should change these to
SUBTOTAL(9, ... ).
Hope this helps.
C...Multiple hyperlinks in one cell
I'm stuck with an excel problem which I cannot solve. I want to pu
different messages in one cell and add a hyperlink to some of thes
For example I want to put this information all into one cell
"message1 - message2(with hyperlink) - message3(with hyperlink)
I really hope it is possible to create multiple hyperlinks within on
cell, but for now I can only add a hyperlink to a cell.
If you would know how I could fix this issue I would be reall
Thx in advance,
Message posted from http://www.ExcelForum.com
If it's really...Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...How to get SUMPRODUCT on filtered cells
I'm currently using the formula
This gives me the number of the full range of cells but I need this to
update whenever I use a variety of filters.
Any help is greatly appreciated
Say we have data in A1 thru B29 like:
and are appling autofilter to column a. We want to use sumpr...Comments in Cells disappear after time
A colleague has a spreadsheet with lots of comments in the cells and
apparently after a while the comments 'disappear'. Does anyone have any
ideas why this happens? Could it be there is a maximum number of comments,
or do they have a life expectancy? The sheet is opened in Excel 2000 & Excel
2003 depending on the user.
Thanks for your help.
Comments don't normally disappear on their own. Perhaps your colleague
is accidentally deleting the rows or columns in which the comments
occur. Or comments could disappear if another cell, with no comment, is
dragged onto a cell ...How can I drop a flyer from Publisher into PowerPoint as a slide?
I have created a flyer in Publisher but I now need to drop it into PowerPoint
as a slide, is this possible?
No, not really. You could open up both instances, Powerpoint and Publisher,
and then drag and drop/copy and paste from the Publisher window to the
Powerpoint window, the reformat as needed.
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"melann" <email@example.com> wrote in message
&...make column lists for select query.
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
I think you may want some dependent lists.
> table1 col1_1
> table1 col1_2
>...can't send anything in Outlook 2002
I just sent a post asking for help because I can no
longer send email with attachments. After sending in the
post, I went back to Outlook and clicked on the
Send/Receive button just to check if I had any new mail.
I got the same message: "The operation failed". So I am
totally out of business with Outlook. How to solve the
Did it work before? Did you change anything in yr settings? Are you sure
your internet mail account settings are valid (correct username, pw,
"Marilyn Fogelquist" <fogel@cablespeed........go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a
"interface" page, remove them, and paste to a string of cells o
another. That is easy, but I cant figure out how to make them go t
another set of cells, if the ones I recorded are filled.
' Macro1 Macro
' Macro recorded 8/4/2004 by Lane Lacy
ActiveWindow.ScrollColumn = 239
Application.CutCopyMode = False
What is necessary to graph the number(s) in cell(s) when the number in that
cell(s) is/are generated from a formula in those cells?
Graph them in exactly the same way that would have done if the numbers had
been typed into the cells.
"mikaman" <firstname.lastname@example.org> wrote in message
> What is necessary to graph the number(s) in cell(s) when the number in
> cell(s) is/are generated from a formula in those cells?
...Copy filtered data
Let's say I have data in A1:Gxx. Now I use Autofilter to find all rows which has a "2" in column C. Let's say it leaves rows 1:4 and
8:10. Now I want to copy the filtered data in columns F:G and paste the values (not to an empty range which is easy) but to the same
cells in colums D:E.
Try Advanced Filter, excellent tutorial here from Debra Dalgeish, owner of
"Hans Knudsen" <Hans.Knudsen@mail.tele.dk> wrote in message
news:%23xtVdlR8FHA.740@TK2MSFTNG...How can Journal be used if Project is not installed, or on the net
How can Journal be used if Project is not installed, or on the network
Network Support Technician
The Journal folder works without Project being installed at all. It's an
integral part of Outlook. What functionality are you seeking?
"Rusty" <email@example.com> wrote in message
> How can Journal be used if Project is not installed, or on the network
How can Journal potentially affect the Exchange server, and I would like more
information on Journal for a Outlook foundation class?
...Merge Cells #5
I know how to merge two cells using formula =A1&B1, but can someone tell me
how to insert spacing between the two within the new cell. I'm merging a
part number and description, and need spacing between them.
the " " is showing that you want to insert text, and that the text is a
space character. It could be "-" or ".", etc.
"R. Stevens" <R. Stevens@discussions.microsoft.com> wrote in message
> I know how to merge two cells using formula =...Excel Cells Contents to HTML Pages
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTMLCode clumn has actual HTML Code like:
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
...How can I tell if our GP 9.0 is updated to the latest SP and patch
We recently upgraded our GP to 9.0, but I'm not sure we are at SP1 or the
latest patches have been installed. Is there a way to tell from the versions
numbers displayed in the "About Microsoft Dynamics GP" box? Or, maybe asked
a different way, if at the latest updates, what should the Dexterity and GP
9.0 version numbers be at?
You know if it's Dynamics GP SP1 when you see that:
Dynamics GP - 9.00.0259
Dexterity - 9.00.0068.0
On Oct 6, 6:35 am, dcnjoe60 <dcnjo...@discussions.microsoft.com>
> We recently upgraded our GP to 9.0, bu...Multiple conditional formating for one cell
I have a workbook with several sheets. Sheet1 has several hundred rows of
text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2
I have I have a cell that allows my users to free hand type in a keyword(s)
to search for in Sheet1. This cell is also has a reference name of
Now comes the question..... I like to for the user to type the keywork into
"Special_Char" and any or all the rows in Sheet1 that contain the keyword as
part of its text to turn yellow. Is there a way to do this? Please keep in
mind that the keywork i...Chart
Subject: Chart - Title Widths
Date: Tuesday, February 03, 2004 12:43 PM
Chart - Title Widths
Does anyone know how to find the width of a title/axis title?
...How Can I Tell What Button Was Just Clicked?
I have a bunch of images on the sheet that calls ONE function.
Is there a way I can tell which button was clicked within the
I'd hate to make a function for each image.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
See one technique at your other thread.
> I have a bunch of images on the sheet that calls ONE function.
> Is there a way I can tell which button was clicked within the
> I'd h...Money 2002 Can't seem to download sucessfully
I have been trying for 10 days now to download banking
info from my various accounts into Money 2002. Before it
worked, now for some reason it is showing that it is
downloading, but doesn't import into the Money program.
What happened? I created a Passport to work online, but
that is the only thing that has changed on my end. Can
someone please help me!!?!?!?!??!
>I have been trying for 10 days now to download banking
>info from my various accounts into Money 2002. Before it
>worked, now for some reason it is showing that it is
>dow...Does anyone know where I can download EXCEL.MSI?
I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3
without this file.
...Outlook 2003 Contact data
Just starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <firstname.lastname@example.org> wrote:
> When composing an e...How can I instantly delete emails? I get a strikethrough + purge
...How do I add a value to a cell every 30 days?
I'm trying to create a calculator using Excel where in I add a given value to
a cell every month. This is not a financial equation.
assume you want to add 10 every month, starting one month from today:
=DATEDIF("2/11/2005",TODAY(),"m") * 10
or, every 30 days:
In article <BC7BB5B0-A994-4ABC-8200-8E198C51C3E1@microsoft.com>,
"ZZ430" <ZZ430@discussions.microsoft.com> wrote:
> I'm trying to create a calculator using Excel where in I add a given value to
> a cell every month. T...copying data
Getting errors when copying data from workbook to workbook. Shutdown and
restart allows without errors.