For a sub total in another subtotal I'm look ing for the second
selection. at the moment I'm using this code but this takes very long
(it repeats 80 times for 140.000 rows in total)
Does anyone have a sugestion tot select the data  my second subtotal

I gather similarly structured data from about 30 different sources.  These
data are in matrix format (15 rows by 23 columns).
To be able to analyze the data with pivot tables, I want to convert them to
a flat file format, with pr line the row label, column label, and value.

Is it possible to setup Excel that when click on Open icon Excel opens an
spesific file?
Thanks,

I have a worksheet with two columns:  job titles and job codes.
I have 15 other worksheets that have several columns including job code, and
I need to add the job title in a column next to the job code.
Example of 1st workbook:

to check if the values in two sheets are equal

I am using Excel 2003.  After using Alt + down button, is there a key I can
press to select "(All)", i.e., we can press "B" to select any enteries in the
column that start with "B"?

I would like to insert a row in a worksheet and keep all the format of the
row above.  This includes where the cells have been merged.  All the
formating remains except that the cells become individual and then have to be
merged.  Any suggestions welcome

Hi;
I need someone's help urgently.
I've few columns of data as follows in my spreadsheet currently:
Employee Number     Plan Enrolled

I have a spreadsheet that uses drop down lists of names and other data using
Name,Define and Validation ofthe lists.  This has worked fine for months and
then all the drop downs disappeared and I cannot get the spreadsheet to
accept them when I attempt to re input them - all the ...

Here is what I am trying to accomplish:
I have a spreadsheet where I would like to pull in parameters from another
spreadsheet.
I first used "GetOpenFileName" to get the name and path of the data file

I can't use the keyboard short cut "Alt I" to insert a highlighted row after
I upgraded to 2007. Any ideas what the new short cut is? (Shift+Space still
works to highlight the row).

Can anyone please help me.
I am trying to create a function that will sum up a column of numbers if
another cell in another column equals a particular value.
I have 2 columns with values in them - e.g.

I liked the fill options we had in Excel 2003. They do not appear to be
available in Excel 2007 - which only has the picture texture fill options.  I
want the standard cross hatching etc fill options.  How can I get these in
Excel 2007?

Well I purchased 4 books, aan I've been learning more about EXcel and VBA.
Its a hard and fast learning curve. Excel is offering more capabilities than
I ever thought! Anyway...I have a problem as below:
I have two workbooks - Workbook 1 and Workbook 2

Hi all, is it possible to put a watermark in a spreadsheet?