Hey guys
I want to show the filename/path directly in a celle, of course I can
show it in the prewiev option, but are there any function to make it
appear as a value in a cell.

I am creating a business model for an Internet portal. Obviously I
used Excel to create this model, unfortunately I ran into the
following problem.
I created a worksheet that calculates the turnover in a couple of

I have a workbook with 30+ sheets. None have more than 20 rows of actual
text in cells but some sheets are 1000s of rows long with blank cells
(indicated by the scroll bar).
All of these blank cells are exported when I 'export to web page', which is

I have a spreadsheet in which the <Enter> key causes the cursor to
move one column to the right.  But, when in the last column for this
sheet I'd like the <Enter> key to cause the cursor to drop down one
row and go to column A.  I know this can be done with a macro, but can

I have to input client's last and first names ( 2 different columns).  I want
to be able to type the last name and each cell in the last name column will
change color automatically when I type. I know how to color the whole column
but not this method. A coworker was able to do it ...

I have a list of data that measures deviation from a starting value
throughout the day on 15 minute intervals.  I need to separate the data in
that daily range and copy into another sheet.
The data looks like this:

I would like help with the following:
A1 : Start Date
A2 : End Date
A3 : $500

Frequently, when turning on my computer, I will get the message something
like "Excel has encountered a problem and needs to close."  I may not have
used Excel for days and it definitely was not open when the computer was
turned off.  Any clues?  Do I have a problem?

Good afternoon All,
I need a VB statement to save a copy of the sheet i'm using (same were the
macro is executed) with a cell value (EG cell "B2") of the workbook I'm
using into a predefined path (EG "C:\").

I have entered the formula onto my spreadsheet. However it doesn’t work if
you have Microsoft Office Excel 2003!
000001    00001001    CLUB CASH     =SUM((A2:A132="000087")*(B2:B132="000088")*D2:D132)
000001    00001002    CASH    

Please, help!
I am trying to recreate a macro that opens a workbook, goes to Sheet
1, pastes clipboard info into A1, then moves to B1, then saves and
closes the file.

how do I do subtractions in excel.

I have created a pivot table with multiple calucalated fields. I need to be
able to calculate the % change between two of these columns, both are running
totals. I know that the formulas that I have used would, and do, work for any
other column, except those that are calculations ...

Is there any way to resize an images, company logo, placed in the header of a
worksheet?

All of ur guidance is very useful me. Thanks a lot.
I have one User defined function in my book. Evry time I'll open this
book.
then open proces workbook. How to use on my book's function in active