I have a huge number of comma delimited excel worksheets and need to copy or
append them into a single worksheet.  There are over 7000 records on some 300
worksheets, so doing a manual copy and paste would take a lot of time.
If I cannot do that in Excel, is there a way to do this ...

I have a cluster of autoshapes (map of a city divided into regions)
that I need to colour according to how much that region spent on
services.  I have a column with the region names, a column with how
much spending was predicted and a column with the real spend.  I have

Is there a way to diasplay in a cell the "Last updated date" the workbook was
saved without using a marco?
thanks in advance,

I need to count some cells with dates with conditions, count if something is
on the next column.
26     9/12/05
30     9/12/05

   In column, there are some data as
A1: 0001
A2: 0002
.

Please can anybody help - I have 2 database's in excel. At present
copy a range of cells in database 2 and in database 1 find the nex
empty "column A" row and then paste ( values only ) the data.  Is ther
a macro that could do this for me so it looks down "column A" and find

Hello from Steved
Yes I have it VBA
Here is my issue I have A Pocket Computer with excel, it does not support VBA
Ok in cell B6 I type in 1430 I hit the enter key I need it to change to

I need some help in coming up with a formula that counts the frequency of
something that also matches a particular criteria.
I have a list of people and the duration that they took to do something:
Person    Duration

If i have a range, lets name it "Names" and i want to find if the name
George is in that range, what formula should I use?
TIA
sheila

Finding stuff is rather frustrating... online is "slow"... whatever happened
to the option of standard help files on a local drive? The whole help
interface is "dumbed" down... even if I was a 9 year old kid I would find
your online help a useless maze.

I've been trying to sort my spread sheet.  It is a attendance sheet.  I what
to have the names in alphabetical order and thier attendance correspond with
them.
I've tried everything.  I've used and tried every sort in the help menu but

Hello from Steve Dee
From other Company information is in columns A to J
From our Company information is in columns L to W
The columns i would like to sort are A and L

Im wondering if anyone knows how I can access a list of shortcut keystrokes
assigned to either in-built excel procedures or custom macros for microsoft
excel.
I want to avoid applying a custom macro to a keystroke that is already

Hope you can assist.
Excel 2003, SP1
XP Home
---I am using '=Countif' to extract only 1 criteria from another

when i link a cell on one page of a workbook to another page in the same
workbook, all that displays in the destination cell is the formula, not the
origin cell data.