Filtering depending on value of a cell
Hi to all,
Is it possible to filtration according to a value that is typed in a certain
Colomn B contain month names: Jan, Feb, ... until Dec. Is it possible to
filltering using VB Code or Macro.. depending on the value that I type in
After that to print the filtered range starting colomn C until colomn L
after hiding colomns F,G,H,I . Colomn headings are in row 6
Yes, you can program the Autofilter.
Have a look in the newsgroups here, that kind of question has been answered
a lot of times of before.
You can reference the value of a cell using:
Sheets("nameoftheshee...OWA problem with changing local path in IIS
I am migrating an Exchange 5.5 org to 2003 with 16 sites. We're about half
way through the migration and have had a problem with OWA defaulting to the
domain name of the site where the hub resides. In IIS on the Exchange
virtual directory we can reset it to the local desired domain name, but it
eventually resets back to the default domain.
Example Exchange virtual directory local path
\\.\BackOfficeStorage\domain1.edu\MBX is the initial setting.
We change to the local domain \\.\BackOfficeStorage\domain13.edu\MBX . But
it eventually resets to the first setting.
...how do I get imported addresses to autocomplete first time out
I have just upgraded from Outlook Express and cannot now get addresses in my
addressbook imported from Express to autocomplete without laboriously
entering each address in full the first time I use them. It's taking me
forever. Is there somehow I can introduce Outlook to my entire addressbook
on a batch basis, or is it really necessary to do it one name at a time?
You don't understand.
Autocompletion has nothing to do with your Contacts. It uses a cache of
names that will be populated as you send messages.
"Frustrated user" <Frustr...Change Brokerage user name and password
How does one change the login information (user name and password) for a
brokerage to download info?
I have gone around and around a million times and can't find it.
I really hate 2007
Look up the following Help Topic:
Update Money with a changed bank or brokerage password
"David Schwartz" <email@example.com> wrote in message
> How does one change the login information (user name and password) for a
> brokerage to download info?
> I have gone around and around a million times...Dual Displays
I want to connect my Sharp Aquos flat screen TV to my computer, and see my desktop on both the TV and computer monitor.
Windows Vista Home Premium.
HP Pavilion a1610n computer.
Galaxy GeForce 8400 GS graphics card, outputs: 1-VGA, 1-DVI, and 1-SVGA. There is no HDMI port on the card.
I connected a VGA cable between the motherboard "on-board" VGA port and the TV, figuring that I could use that output to work with the TV. The computer monitor is plugged into the GeForce graphics card.
Tried the Desktop "Display Setting". It says, the number 2 monitor is "N...Find cell which returned maximum value in formula
De, try this, =CELL("address",INDEX(A:A,MATCH(MAX(A:A),A:A,0)))
will show the first one if there are more than one
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"De" <De@discussions.microsoft.com> wrote in message
Thanks, Paul, but I found this hard to follow. Excel kept returning that I
had disabled macros but yo...Display a message box "this entry is a duplicate"
How can I display a message box on a form if the shipment number is a
duplicate? I need a message box to pop up when user attempts to tab out of
Private Sub txtShipNum_BeforeUpdate(Cancel As Integer)
If DCount("*", "MyTable", "ShipNum = '" & Me.txtShipNum & "'") > 0 Then
Msgbox Me.txtShipNum & " already exists."
Cancel = True
This assumes that your text box is named txtShipNum, that the name of the
field in table MyTable is ShipNum...Folder could not be displayed
I am running Windows XP and Outlook Express 6 just fine
then one day my husband does something to my computer and
his email account won't work. My email is working just
fine but in his he cannot open his inbox. It says folder
could not be displayed, and when you send and receive it
gives you this error message:
"An unknown error has occured.
Server:'incoming.verizon.net'.Protocol:POP3, port: 110,
Secure(SSL): No, error number: 0x800C013B"
If anyone could help me with this I would greatly
T...how to display values in 3 cells into one cell
Anyone can help me how do I display the 3 separate different values in 3
cells into just one single cell ?
thanks so much in advance.
Either there was a typo or there's an echo in here.
That line should have been:
= A1 & " " & B1 & " " & C1
"Bradley Dawson" <firstname.lastname@example.org> wrote in message
> In the target cell, type:
> = A1 & B1 & C1
> where A1, B1, C1 are the cell addresses that you want to concatenate.
> If these have number...How to create a 2 columns and 2 lines graph with non-related value
I am trying to create a graph with 2 columns and 2 lines. I am able to get
the 2 colums ($000 value) and one line easily ($000 value), however the 4th
data series is completely out of range (it's a percentage value ranging
between 8 and 10%). I can see the line completely flat on the bottom axis but
would like to be able to move it up so it kind of "hangs over" the columns.
Any ideas that do not involve complexed programming?
Double click on the line, and on the Axis tab of the Format Series dialog,
Jon Peltier, Microsoft Exc...How to disable auto-capitalization of first letter in Outlook eMail writing?
When I write new eMails in Outlook then always the first letter on new lines
is automatically turned into a capital letter.
How can I turn this "feature" off?
Characters should be taken as I type them.
Tools, Options, Spelling tab, Auto Correct, turn it off or change the Auto
Correct Options. If Word is your editor, see the instructions for auto
correct in Word's Help.
"Sven Claasen" wrote:
> When I write new eMails in Outlook then always the first letter on new lines
> is automatically turned into a capital letter.
> How can I turn this &quo...How to select & display distinct values
I need help with a form please.
My form has two controls, the first being a combo box. This box should
select the company name from a lookup table. The lookup table has only two
companies in it, however, they each are repeated several time. Company 1 has
about 10 rows, company 2 has 3 rows. I used the query builder and came up
with the statement:
"SELECT DISTINCT Lktbl_Role_Master.CompanyName
When I run the statement directly from query view, it executes perfectly and
returns exactly two rows (one for each company, in a datasheet view) ho...Changing Codes
I have a series of product codes that all begin with a zero e.g 0455
I want to change all the zeros to a 9 is there a quick way of doin
cj21's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2567
View this thread: http://www.excelforum.com/showthread.php?threadid=40144
Maybe using a helper cell and using a formula?
(255 is just a very big number to get the remainder of the text.)
If these are numbers just formatted to show ...Display Time in Outlook
The time setting in my Outlook is one hour behind my
actual time. I cannot determine how to change the time.
Outlook is the only item that is incorrect. Other display
times in operating system are correct. Thanks, Jodi
...My first post and 11 Hilarious videos
As the title says 11 hilarious videos I've gathered from the last week.
Enjoy ;) '*Webcam singing goes wrong*'
(http://tinyurl.com/aht7k) - '*The wedding slapper dance*'
(http://tinyurl.com/75l8a) - '*Wedding couple runs into door*'
(http://tinyurl.com/8vxxc) - '*Bloody skate crash*'
'*5 car crashes in 55 seconds*' (http://tinyurl.com/cfnhg) - '*Woman
attacked by Bull*' (http://tinyurl.com/bjhlf) - '*Granny gets run over
by her own car*' (http://tin...Hide rows with value "Hours"
I would like to toggle rows to hide/unhide based on the value "Hours"
in column B. I think filtering is an issue to some blank seperator
rows and merged cell headings. There are no merged cells involving
Column B. Thanks.
Public Sub ProcessData()
Const TEST_COLUMN As String = "B" '<=== change to suit
Dim i As Long
Dim iLastRow As Long
iLastRow = .Cells(.Rows.Count, TEST_COLUMN).End(xlUp).row
For i = 1 To iLastRow
.Rows(i).Hidden = .Cells(i, TEST_COLUMN).Value = "Hours"
Anyone have experience with being acquired, but stayed on the current systems
of MS Dynamics GP?
We were just acquired by a new owner. Our companies and operations will
stay the same, except we have a new holding company for the new parent. If
we are going to stay on MS Dynamics GP, what would be the best way to
transition to the new ownership and have a clean cutoff of the old ownership
vs new ownership?
We were considering two options -
1. start new company db's for each company acquired and copy over our old db
to the new db, but remove all the historical tran...PK and FK Displayed
I am a complete Visio newbie, and cannot find the answer I need in books or
I am trying to create ER diagrams from scratch, and not connected to real
tables, using VEA. I have added tables ('Entities') to the form, connected
them with a Relationship connector, and, in the Database Properties window
I've assigned the end points to a Primary Key on the left and a Foreign Key
on the right. But the model shows the connector as running between the top
colums on both sides, whereas I want the keys to be in that upper box and
provide the connector's end points. Wh...Changing Constants in several macros in one go
For a table macro (see below) I have defined two constants ...
.... strConstantBlue: representing the RGB value for borders,
.... strConstantBlue_2: representing the RGB value for background
I got SEVERAL similar table macros all with the SAME constants, i.e.
.... strConstantBlue and
How can I set NEW values for these two constants in all the affected
macros in one go, using an InputBox?
That is, after entering the new values for the constant
<strConstantBlue>, say (44,33,22), the values for these constants have
to ...How to change default formatting
How can I prevent Excel guessing what it thinks I want to type in a cell
If I type in 1/2 it thinks I want 1st February 2003, but I just want "1/2"
If I type in MAR01 it thinks I want 1st March 2003 but I just want "MAR01"
Its a real pain!
I knew about that one thanks. However I want to avoid having to do that
every time. Any other ideas?
"Kevin Stecyk" <email@example.com> wrote in message
> Try preceding the "text" with a single ' (apost...Pasting a value as an hyperlink
I have imported a list from a database of file paths to documents on our
server, these data is currently formatted as 'General'
Is there anyway of converting that value into a hyperlink to the said
If your list is the complete path and file name, then in an adjacent
column you could just do:
and copy this down.
If you wish to you could fix the values and then you would not need
Hope this helps.
On Apr 20, 4:14=A0pm, The Rook <TheR...@discussions.microsoft.com>
> I have imported a list from a data...Formulas are displayed, results are not
Hello, For some reason, when I enter a formula into a cell and press
enter, the formula just stays there. Anyone know what I can do to show
I tried pressing Cntrl + `, but that didn't work.
FYI, when I cut and paste a column from a separate workbook, that
column works like normal (i.e., the formulas produce results).
Thanks for any suggestions!
Maybe your cell is preformatted as Text.
Try formatting to general then erase your =
and type it in again.
"Mike C" <firstname.lastname@example.org> wrote in message
news:f699bcd4-ad82-4a88-9759-5638c147b...validation list--list depends on the selection of first list
I think this question has been answered before but i can't seem to find
anything related to it. I wonder if this is even possible?
I have about four items on the first validation list that i can choose from,
and based on what is chosen on that list, the second validation list should
only show the list of items that are related to what is chosen on the first
For example, on the first validation list, there are these items: A, B, C, D.
A has 1, 2, 3, 4
B has 5,9,30,2
C has 0, 12, 6, 10
D has 66,44,33,22
If i choose A, then the second validation list should only list...Stop displaying a line
I have a line graph/chart and it gets its values using a formula and the values of another column. However this poses a problem because if there is nothing in the targetted column the formula returns 0 cause the line to drop to the bottom, instead of casuing the line to just end until a value is added to the target column. How can I do this?
Change your formula to use NA() if the cell is empty. For example:
To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions here:
http://www.contextures.com/xlC...Change language event
Is there a message that I can handle when the user changes the language from
the language bar ?
> Is there a message that I can handle when the user changes the language
> the language bar ?
Try WM_INPUTLANGCHANGE and see where that gets you.