I need help creating a macro that reformats my data in excel and places it on
a new worksheet within the same workbook.  It will use relative addressing so
that it can convert new lines of data.  Data must be reorganized before it
can be imported into a database.  Thanks for your ...

I am sorry to post the query once again.  I main school data base in excel.  
The database has around 1000 student entries.  It contians student id,
student particulars, fee structure and etc.  What i want is i would like to
incorporate the photos of the students and when i select ...

I'm running Excel 2002 for a spreadsheet to keep track of access codes for a
security system.  Some of the feilds start with a zero, so I have the cell
formatted as text.  When I enter the number I'm getting a small green
triangle in the upper left hand portion of the cell.  When ...

There are several sheets in the workbook titled Sh00, Sh10,Sh20...... I am
compiling data form the sheets on to a sheet tilted Sh700. In one of the
columns the formula in the first cell is: =Sh00!$L$10. The data in the
subsequent cells will increment the previous sheet by 10, i.e ...

I am struggling to copy math formulas from one workbook to another.  I only
want the formulas to reference specific sheets in the active workbook.

I need what is probably a simple formula.
I know filtering will do it, but this is from an unattended workbook,
so a formula would be best.
A1:A40 = range named "clients"

I have excel sheet that has a vlookup formula and conditional formated
accoridning to dates.
I want to select the data and special paste only values and formats to
another worksheet and those dates to become a formula so that  the

I'm having difficulty creating a pie chart for the following data:
Method of Payment        Relative Frequency   
Cash                                      81.1%   
Checks                                       7.6%   

I'm looking for a time sheet for the whole office, and I jave found just for
one team mnember.  Can you help me please

I need to convert from 50d35'25" (survey instrument notation of an angle) to
the decimal equivalent of 50.59027778. Is there a function that will
automatically convert this? If not, any suggestions of a formula?

I'm trying to enter a 17 digit number on a cell and somehow it always changes
the last 2 numbers into a ceros.  I have tried to format the cell to number
and general and it coutinues to do so.  but only when I enter a large number
ei: 43343302223640001 then the one will auto ...

Hey all,
I'm wanting to just click on a cell and it automatically input "P"
kind of like a option button.  I have a column set up so that if ther
is a "P" in the cell I can sort the sheet to show only those rows wit

I have excel 2003 installed and am looking for a solution to this problem
I have pay periods of Weekly    BiWeekly    Bi Monthly   and Monthly in cell
A2 and they are selected by a list by data validation with a pull down.
I have in A10 a date that the payroll first begins for this ...

I am working with a very large workbook and need to remove unformated or used
rows and columsn.  I am new to excel and need some help please.

I am triing to add cells (a1:c1) on sheet1 and have the formula on sheet2 but
have it output it to e1 on sheet1.
I am tiing to have the formulas on a different pageso that the person using
the sheet cant see them and or mess with them