I'm a normal excel user, and i would like to know if there's an eas
way to apply a filter to ONLY ONE column. Autofilter just seems t
apply it to all the cells in a row. If it implies adding some code,
don't care, but please try to keep it as simple as possible.

I have several field that I need to name.  If I have the names of the
field in cells (in the cells, not the name box) of another worksheet,
is there a way I can copy and paste the text in the cells to the name
box of another cell?  I think a macro is required for this, but I'm not

I'm trying to create a spreadsheet that pulls data from another
spreadsheet in the same file as well as data from other files. In the
attached spreadsheets, I have fields that find the largest value based
on dates entered in multiple cells (ie. In my first spreadsheet, I have

how in excel can i tell that
1
2
3

I have a simple Excel spreadsheet with two worksheets. I want to hide a
block of columns on Sheet 2 if there is text (e.g. a date) in a cell on
Sheet 1.
For example if Sheet1!A2 has a date in it, then hide or show columns A

is there a way to pull out what's principal and interest from a mortgag
payment calculation
--
mikecookax

Hi all -
I have built an application in excel which in its essence is a database of
bonds that our firm trades.  I also built a custom toolbar by which end users
will be able to filter and search for certain bonds based on thier desired

Is it possible to install and configure a virtual server...back it up to
file using NTBACKUP and then restore to a real live machine?
TIA
KIWI

I am a teacher and grade tests using excel.  I have a master template
of my MC test scoring sheet and copy a worksheet for each student and
input their data.
Once all their answers are inputted, formulas spit out their raw score

Looking for a tool, or code that does the following.
Edit [partial cell data] in Sheet1, if [partial cell data] meets criteria in
Sheet2, COL1.  Sheet2, COL2 has the REPLACE WITH information.
Presently there are 59 criteria on Sheet 2, and I have to perform this

Hello,  I think this is a relatively easy question.  Can someone let me
know what the correct syntax is below?  Thanks in advance
Sub MyTest()
Application.ScreenUpdating = False

I have a workbook that has lost it's controlbox.  I an unable to maximize,
minimize or resize the workbook within excel.
Please help.
Thanks,

Please forgive this off-topic inquiry.  I appreciate your indulgence
and your patience.
Can some tell me what MS Community Newsgroup or public
newsgroup (e.g. microsoft.public.*), if any, that I can post to

I have Excel data (raw) that I am importing into an Excel sheet which
has my formulas).  I am trying to add up a column of numbers, but some
of the fields have the letter's "N/A"
Presently I am using formula =sum(A10:A15000), but it is not working

I often copy accross large lists of data from web resources, when I d
this, each of the cells in one column contains a small picture whic
remains on the worksheet even if I have moved the data elsewhere.
I can get rid of them using "cut" - but it would take too long to d