Daily csv files are dumped into a shared folder and i have written a
macro that goes into that folder and automatically pull in data to put
it in microsoft access tables. What i want to do next is after
importing the data into access, rename those files to include dates and

I get a data dump from a large cooporate database  that I use for data
mining.  I need to "massage" the information (get the dates in proper
formats, numbers as well, get rid of unwanted columns, dump records
with incomplete data etc)

I am working on a VBA script which I want to loop until it fills all
rows in excel, or the user stops it by clicking a button.
By hitting ESC it will take out all delays that I have in the script
and the script will finish off the number of "loops"--I would like to

I have data in the following format:
A1       B1
123    1223
12       2356

I have a table of which lists 50 employees and their skills. Cell codes ( D
= Day, 24 = 24 hr cover etc etc etc) are used to show if they are at work
and if so what type of shift they are on.  The table logs a months work
rotas at a time and can be very difficult to follow.

Excel 2003
I'm Using Vlookup to find data from named table arrays.  The looked-up table
array name changed depending on the value in a cell (eg a2) and the column
header (eg Base).  I'm trying to create the name of the table array by

I am trying to create a spreadsheet to help me work out the klms rating
of my van. I drove 1933.33 klms, used 187.626 liters and the van should
get 8.8/100 klms.
I would like to be able to compare another vehicle against the van by

How can I make pivot table query for parameters like data range, I have
done something like this in normal query by adding [Ask For Date:] in
MS Query.
Does anyone know how to achieve similar result for Pivot Table.

Something is staring me in the face but I'm not seeing it.
All I want to do is create cells with "Step 1, "Step 2," Step 3," etc.,
with automatic sequencing of the Steps and automatic (if possible)
entry of the word "Step." I can do it in Word, but in Excel I can't

i want a spread sheet with a minimum number of rows and columns(sa
rows=15 cols =5 ) can we do it. the rest of the spread sheet will no
be visible(other than freeze panes
--

zs#$d

I have a pivot table and it size is very large say 50 MB and it uses an
access database which is 300 MB to create it.Is there any better way of
doing it?As I really want to reduce the size of pivot.

I've used Excel 2003 for some time - no problems.  Today, I began using it
on my wife's notebook.  I note that on several of my transferred in
worksheets, a small triangular mark appears in the upper left hand corner of
a number of cells.  It looks (other than the location) like ...

What formula do I use for elapsed time so I can calculate calories/hour from
my exercise routine, for example?  The routines vary in lengthI can calculate
average time and average calories but is there a way I can use the
hour:minute:second format (or some other elapsed time ...