I cannot locate the "Create List" command anywhere, yet in the beginning
article on pivot tables for excel 2002-2003, it says to start with a "list: A
series of rows that contains related data or a series of rows that you
designate to function as a datasheet by using the Create ...

I have a column with text emails in it of the text form "person@website.com"
I wish to convert the entire row to hyperlinks to email ...
If I click on "HYPERLINK" and then select email it gives this hyperlink the
text name

We are creating a form for vendors to fill that would contain many rows of data.  Most likely they will be
copying and pasting their data into it or dumping it from a database somehow into the form, i'm not really
sure, but I would like each row to get numbered as data is entered.  ...

I am struggling to find a solution to match my requirements & would
appreciate it if somebody can help me out. I have a spreadsheet with just
under 4500 lines of information. For each line, there are around 10 entries
(i.e.... 'description', 'shipment number', 'order number', ...

Using XL2003 on Win XP Pro with all the latest patches etc, a rather
strange thing is now occurring in the VBE.
Each time I open a file in Excel, it appears in the VBAProject list
(as per normal) and all works as expected ... no problems there.

I have a list of 100 company names in a sheet called: Names
In other sheets (not 100 sheets but about 30 sheets) I draw a graph of daily
price for those companies. Graphes are stored as sheet not as object and
there is only graph with no data cells

I have single col with 9000+ entries. What I am looking for is a formla that
will look similar to this: B1=a1 &","& a2 (combining the two with comma). I
have no problem with this but I am needing the formula to split this into
cols of no more than 300 rows. So ending result will ...

hey i want to 'flatten the hierarchies' in a pivotTable and basically
repeat the duplicated rows
so right now i have
US     NORTH

I remember learning how to create a range that allowed entering new data
which in turn dynamically changed the range limits.
Can someone point me to an example with the relevant Excel functions?
Thanks,

Hello everybody !!
Do you any idea for my problem ?
I've a column with times : HHMMSS
145204 == 2PM 52 min 04 sec

For example worksheet 1 Column A B C D & E have multiple
Numbers ranging from 2001, 2010, 2017, 2025, 2027, 2036 &
2038. Worksheet 2, 3 & 4 Have the same.
What i want to acheive is something to look at each

I there a way to copy a workbook without copying any data. I would like to
copy formulas without  any data in the cells or notes for the cells being
copied.
I tried to put value Zero on all the cells but it's wipeout the formulas.

How do i increase a cell which has a number in it, eg, cell a8 has 4
i want to run a If statment that looks at another cell and if true i want
cell a8 to increse to 5

I want to create a submit button that when I click on it, the current
worksheet/file will be e-mailed to someone.  Instead of saving the
file, then inserting into an e-mail.  I have seen this before in a
file before, but can't figure out exactly how it works.  I happened to

i want to set up a spread monthly numbers sheet that automatically totals how
do i do that?