I was given a spreadsheet with the following columns:
a button column (to run a macro)
a persons name
6 monthly columns of figures

I currently have a VLOOKUP function set up in a cell.  I am interested in
setting up a conditional statement that goes something like "If the drop-down
cell is null, display nothing, else use the VLOOKUP function defined"
This is purely for aesthetic reasons, I don't want to have ...

Hi
Experts
I want to group 12 cities in 3 different groups named as class A, class b
and class c .  three colour assigned to each class.  when I enter  a city

How do you separate a date into seperate columns??
i.e. December 15, 1978
from one cell into three different cells, one for the month, one fo
the date, and one for the year.

I have a spreadsheet with 32,000 rows and 15 rows.  When I copy data from the
spreadsheet and click File New and then paste into the spreadsheet it is very
fast.  BUT when I launch another Excel instance and do a paste it is very
slow.  Now if I delete about 15,000 rows, the ...

X-No-Archive
Please help
I have various large ranges in which I wish to sort each row
individually into numerical order. But Excel's 'Sort by row function'

Hi Bob,
Thanks for the quick reply. I've tried it but it didn't work as
expected or maybe i did something wrong. I've already click and paste
the script as instructed but no change. I've attached a screenshot of

Can some one tell me how to repeat a specific command within a Macro?
My case:
In tab 1 I copy in columns of raw unsorted data
In tab 2 the raw data from tab 1 needs to be grouped and sorted

NEWBIE ALERT*:
OK, please bare with me.
What is the method for combining multiple if statements in one cell's
formula?

I have a small macro that is attached to a print button on sheet 1 that
prints the graphs on sheet 2.
My problem is that I wish to print to a printer that is not the default
printer.   Can the printer be selected automatically when the macro runs.

Hi, again.  I am using EXCEL 2003.  I need to import several specific sheets
from a certain xls file into another xls file.  I can't find the information
on how to do this.  Could an expert please explain in easy English how this
can be done?  Thanks.

I'm looking for sample code that allows me to import/export some records
from Excel to Outlook Contacts. Any ideas?
Thanks in advance
Michalakis Michael

Hi Experts
How can I display the icons in the top right corner of my screen for min,
max and close if they are not there.
Thanks

GDay All,
I have a spreadsheet with a number of columns. In these columns, times will
be entered (probably 24 hour style). I need to compare these times and
present the lowest time in another cell. However, I'm stuck for a formula to

Hi All!
I'm pretty sure this is one of the formulas I need, but not sure how to
implement it... Here's what I have:
Column G (G4:G80) Numbers