I am trying to insert a button on a excel sheet which would insert a single
letter into an empty cell when clicked. I am having trouble with the macro
command. This is a first for me and I am stuck. Basically, it's an attendance
calendar, so I need several buttons to represent ...

Hi and thank you all!
I have an AM table (and I have done many), but I need a command to:
1)  When the End of Balance = 0, then
2)  Sum all PMTs BEFORE the End of Balance = 0

Can anyone advise me how to add a formula to an excel worksheet that will
display the most recent "modified" date?  Please note I am familiar with NOW
and TODAY() functions - instead, I am interested in displaying only the date
the file was last saved.  The NOW and TODAY() ...

I have a date (any format, includes m/d/y) in one cell.  In the cell next to
it, I just want the year to appear.  Doesn't seem to be a format to allow
that.  Please advise.

I have a beginning balance and an ending balance, I have the date and amount
of each transaction in this time period.  I am trying to calculate the ROI or
rate of return for my investments during this timeframe.
I have found a number of articles on different Excel function, but I ...

Worksheet contains headings in first row:
Last Name, First Name, Class 1, Class 2, Class 3
Second row contains class locations underneath the class names (for
reference).

Dear Experts
I am trying to create a depreciation table with the details mentioned below.  
I hope what I am trying to convey below is clear enough to understand.
I have columns for Purchase Date, Cost, Rate, Year Days (Closing

i have used Autofilter after the help of you guys, and thanks for that.
Now i have another issue. I have 2 worksheets. In one (Stocks) i have the
table which i use the Autofilter.
In the other worksheet i will have the Summary of the results. However this

Hi,
I've got a huge list that looks like this:
-------------------------------
name data 1 data 2 data 3

Does anyone know how to copy only certain characters from cell to cell?  For
instance, I am trying to copy the first 10 characters from a cell to a new
cell.

How do you beam a work sheet to hand held device that has Excel Mobile.
E-Mailing the worksheet works.......

I'm trying to do a VLOOKUP where the user chooses a currency in one cell B2
Then the VLOOKUP should fetch the exchange rate and put it in to other cells
D6:D12 for calculations.
It's not working :-(

Question:  What function can i use to create an average value of the
previous 7 days?
Column AJ contains data, which is added to everyday
Column B contains the date

New here and would like some help.  Since I am a very very basic user of
Excel I created a sheet to track our Membership Finances.  This is what I
have.
 A                   B                            C       D       E        

Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only returns
22:00 and I have tried to format it different ways but I never get 31.
What I'm I doing wrong with this or is there another way to ...