I have 2 sheets (sheet one and Sheet two)
On sheet ONE  in col A I have a number of entries
I want to be able to click  on any one entry in sheet ONE and be taken to a
brief explanation on Sheet TWO.

My problem is that i am using Input boxes to update a spreadsheet. I
have two coloums i want to update for two diffent type of information.
I am currently trying to use
Sub Compfees()

I was working on a new document.  I pushed Save As.  Somehow I managed to
select my worksheet that I use as a database and saved over it.  I then
closed Excel.  I didn't realise what I had done until after I had closed the
document and tried to open my worksheet I use as a ...

Hi, All,
When I worked with Lotus 1-2-3 years ago, I found that it had a feature
which would show you, on one screen, all the cells in a spreadsheet
that had anything in them.  I don't remember what it was called -- map,

I have a worksheet where I have a column that has number of participants to
attend a class, a column that has the length of class and then a column that
has a formula to multiply the number of participants times the length to get
a total amount of time trained (example 15 people ...

I have 20+ worksheets in a workbook. Each sheet is a timesheet for an
individual and each sheet can have up to eight cost codes which will be the
same on some sheets but will not be in the same position on all sheets. How
do I label or set up a range so I can consolidate all of ...

I need to take text strings in a column and output them in a text
file with double quotation marks (") around them (for processing by
another, existing program).  I cannot figure out how to do this by
saving an excel file as a text file.

I regulary download a spreadsheet which has a filename format of
Data_Date_Time.xls
For example SurveyData_290905_1105.xls
Each downloaded file has identical column structure but a variable number of

How can I loop through all open workbooks  and copy the first sheet in a new
file in Excel macro. I am trying to collect sheets in different workbooks
under one file.

Thx for solving the spacing problem.
I also want to change è,é,à,ö .. into the normal e,a,o. Is there a function
in Excel?
GRTZ, Luc

Can I change the comment box default font and stop it inserting my name in
each box?
Peter

I'm fairly new to Excel:
Does anyone know how to calculate the exchange rate for two given
currencies in Excel? I have the two currencies in my spreadsheet but
I'm supposed to create a formula that shows the exchange rate between

Hi Everybody, Can anyone help me in disabling search function (Control
+ F ) in Excel 2003?

I would like to know what's the easiest way to add a specaial character to
the beginning of all the cells in a selected area in Excel.
For example I have these records in cells A1 to A3:
2*3

Alrighty people, I've been given until the end of the week to finish up
a program that I've been working on as a pet project and there are just
a couple of things that I need to get cleaned up with it.
- the excel program creates two tables, of about 8 rows x3 columns each