Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Pulldown31 Jan 2005 05:06 GMT5
I have in the past put a pulldown in a cell, letting the user click a
little downward triangle and then click a choice to populate the cell.
I can't remember what this is called, so can't use the help to look it
up.  Could someone remind me?  Thanks.  Also I seem to recall ...
Protecting macros31 Jan 2005 04:39 GMT4
I need to password protect macros attached to a workbook - not the same as
protecting the sheets.  All help gratefully received.
TIA,
Dan
design form?31 Jan 2005 03:26 GMT5
What software should I use to design a form for listing my DVD collection?  
Are there templates available somewhere?
if/then question31 Jan 2005 00:55 GMT2
Here's what I hope is a pretty basic question.
I have 5 rows of inventory data.  They are the following:
A1: Product Name
A2: Product Cost
Currency Format Change In Styles-Justification31 Jan 2005 00:24 GMT5
Can anyone tell me how to change the currency format in the styles area
to match the format in the manner as when you got to Format Cell
Currency.
For some reason the justification is in the affected cell is different
Selecting some cells in a column for formatting?31 Jan 2005 00:07 GMT13
I need a macro to select cells in a user input column, only in rows where
the contents of the cell in column AT (say) is X, then apply a set of
formatting commands to the selection.  My VBA syntax and vocabulary are too
shaky for me to be confident of what should be an easy piece ...
Formatting text in a CONCATENATEd sentence.31 Jan 2005 00:00 GMT14
 Is there any way to format certain portions of a concatenated sentence?
For instance, On Friday January 28th, 2005 I earned $ 100.00.  Can I format
the date (say bold and blue) and also format the amount (say red if it is
below $ 200.00)?
how to lookup value on another sheet?30 Jan 2005 21:56 GMT2
I'm going to oversimply my example for the sake of making my point, so
please don't ask "why bother doing that?"
Sheet1 has a list of product ID (SKU) values.    Sheet2 has a list of *some*
of those values, plus another cell that represents the cost of that item.
Chart layover...transparency30 Jan 2005 20:44 GMT4
I need to take three different line charts and put them together and be able
to simply see the plot on each one.  Think of it as putting three different
transparencies on top of one another for a presentation.  Three different
groups produced each chart but they have to do with the ...
Run-time Error 730 Jan 2005 20:16 GMT1
Every time that I open Microsoft Excel 2002 (opening a blank spreadsheet), I
get a Visual Basic dialog box that says "Run-Time Error 7".
It does not seem to be a problem, really.  I just press the "End" button in
this VBA dialogue box and Excel opens just fine.  It's more of a ...
How do I determine if a value in one column exists in another column?30 Jan 2005 19:24 GMT11
I tried
=IF(MATCH(A2,'Equipment Data'!A:A,0),"T","F"),
but it produces "T" for all values - even if they do not exist.
Thanks in advance,
Can I download a free invoce/purchace orders template in Excel?30 Jan 2005 19:01 GMT1
Can you please help me?
thanks
How do I eliminate the "A" designation in column "1" and substitu.30 Jan 2005 18:57 GMT2
I want to substitute my own designations at the top instead of A, B, etc I
want my columns labeled "Last Name", "First Name", etc. How? My chart is all
finished
column (a)30 Jan 2005 18:54 GMT2
When I change the style in column (a) a date it also changes column (b) which
is hour format or style.
Signature

Wayne

Vlookup problem30 Jan 2005 17:55 GMT7
I have two worksheets with some matching data. I'm trying to use the following formula to determine if the values in column A on WS1 exist in Column A on WS2.
=IF(VLOOKUP(A2,'Equipment Data'!$A$2:'Equipment Data'!$B$9000,1),"T","F")
I am getting #N/A and #VALUE responses.
What have ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.