I created a drop-down list...works fine. Now I'm looking to create a feature
whenever one of the items is selected (from the drop-down list) that data
from another sheet (same workbook) is displayed.
Thanks.

How come I see numbers 1...x
instead of the standard A B C columns?
I have Office XP...
Please advise

From my financial package periodically Excell sheets are generated with lot of financial
information. Unfortanely I cant make a selection from that package, so it generates all the
information available.  So, my idea was just to  filter the spread sheet in order to get the
required ...

eg if i have
col1 col2 col3 col4
1      2    3     4
1      2    3     6

I am begining to learn the VBA aspect of Excel in order to develop
applications in Excel. Any suggestions how I may proceed with this
effectively.
Thanks

well, I just miserably failed in posting my first thread. Hope I will
be luckier this time.
I have a couple of matrices (170) in one excel sheet and would like to
calculate the correlation coefficient of all pair combinations. That

I have a Workbook containing 80 worksheets, I would like to create
buttons that when clicked will print a specified selection of th
worksheets.
The issue I have is that worksheets 6,7,8 are printed with eac

I want to make a selection (entire row) from a worksheet en place this row(s)
in a listbox.
So far I'm able to place the cells from the selected row vertically in the
listbox, but I want the row horizontaly (in columns) placed in the listbox.

I am trying to find a way to specify a cell (to use in a formula)tha
contains a number greater than or equal to a specified value.
Hoe can I do this
--

I receive:
"Microsoft Visual Basic
Compile error:
Sum or Function not defined" after I have run a macro. I recorded the macro.

I'm interested in making an Excel 2003 spreadsheet downloadable from the web.
I've created a single sheet, single cell (a1 contains "x") and filed it.  
This consumes 13.5k.  What procedure(s) would you advise to make it smaller
for download purposes?

ANYONE WANT A CHALLENGE?
Can anyone help please? I need help from someone who has knowledge
about pivot tables and, or, templates.
I have a large worksheet of data that is imported into excel every

Entering numbers from a catalog; no cell formatting.  Just a series of plain
numbers.  They are 150,151,154,158,175,177 all entered in one cell.  As soon
as Enter is hit, the commas disappear and the 177 changes to 000.  Thus
150151154158175000. This happens in any cell.  What ...

Is this possible? If yes, Any helpful URLs for this? I appreciate your
immediate response.
MP

 Can someone please help me. I am using Vlookup to look up a table and
bring nack relevant information. When the information is not found
vlookup returns N/A.
Is there any way of vlookup returning an empty cell if no info is found