I have a list of audit questions.  Answers are provided using drop down lists
via data validation lists.
Is there a way to auto populate answers based on a prior answer?
e.g. If the answer to question 33 is "No" I'd like the responses to

When I split a window horizontaly, is there a way to move the upper pane
(right and left) without moving the lower pane, and viceversa?
I tried also using the scrollbar tool but I think that is not its purpose.
Thanks for any help

in VB , when I Cancel or close  an InputBox instead of entering data in
it,an error menu showing error 13 appears.how can I avoid the menu?????there
is a commandbox on my worksheet that by pressing that an inputbox pops up,now
when I close the inputbox without entering the data, ...

I have a workbook and I made a copy of that work book and want make some
changes in Copy Work Book but when I am clicking Save this message is coming
out that :
This work book Contains External Data, Do you want microsoft office excel to

If I have 8 workbooks that employees fill in with their stats and they have
52 sheets for each week.   I have a Stats workbook that has 52 sheets and on
each worksheet is a 8 columns (one for each emp).  This is used to link to
their indivdual workbook to bring in their stats for ...

I hope some one could help me to solve the problem below. I have spent over
one hour trying to solve it, but with no luck.
I have a source data file with fileds of "TIME", "USER", "CPU%" and so on.
The "TIME" field has multiple duplicate time stamps. I want to know how much

I created a button in excel that opens up a new work book when it's
clicked.  I also created a module that grabs data from ms access.  Is
there a way for me to call the module in the button also when clicked
on?

A travel form was created and in a few of the cells when a number is entered
a date appears. I know how to format dates to currency and all that. My
problem is that when I am in the cell that needs to be reformatted and I go
to the Format menu, when I click Cells, nothing happens ...

I have gathered the 2007 month by month home sales in our area and have a
separate worksheet for each month sorted by "year built". That said, how do I
analysis what I have? What function can I find to determine what is
selling...Hot market?  Thank you so Much in Advance for your ...

I am trying to sort alphabetically a list of first and last names. It sorts
perfectly until I exceed 1115 lines. Additional entries are not sorted but
are left in the order entered. Is there a limit on the number of rows or do I
have another problem?Thanks-Merv

Hello kind brains.
I create Purchase orders in Excel - All from the same template. Then i
prepare properties so that the file that contains them displays PO number as
file name - then job number - then amount - then payment method.

I've been trying to figure out how to move items between multicolumn
listboxes.  I have it all expect for one piece.  If I select more than
one item from the source listbox, I don't get all of the selected
items, I only get the first item in the selection repeated a number of

i have 10 files with .dat extention in a folder if i want to open all such
files with excel amd do automaticaly execute the text-to-columns method... so
that i can plot with the files...
please help me

We are having an issue at work with accidental dragging and dropping folders
into other folders.  (You go to open a folder and it's missing!)
Is there some way to prevent this from happening?  Turn off the feature,
Lock the folders, Can a pop up text box that says "Are You Sure ...

(Excel 2003)
Is there a way to fix a vlookup so when it doesn't find a value it just
leaves the cell blank, instead of #N/A? It makes it hard for me to do sum and
other things to the results. IF not blank to replace it with zero?