Is it possible to transfer data from several workbooks in to a single
workbook when the workbook the data will end up in has a different template.
for example the second workbook has 26 fields, but the all the other
workbooks have only 21 fields and I only need the data from 19 ...

I have created a series of Macros in excel, and have alocated them to a
custom toolbar I have made.  Is there a way which I can save the toolbar and
macros with the excel spreadsheet, so tht the whole set-up can be used on a
seperate computer?

Hi.. I need help desparately.  I have two individual workbooks.  Workbook A
contains, application, home country, Id, etc., information and Workbook B
contains id, home country, start date, end date, etc.  In both workbooks the
Id may appear multiple times.    

My director was hit with “Too many different cell formats” on his Japanese
version of excel 2003. I would like to know whether the problem was solved or
extend the limitation on excel 2007?

Is there a simple +,-,x,/ calculator in Off '07?

How do I "shrink to fit" text in the new Excel 2007. I can only find the
"Wrap Text" button which is NOT what I want to do.
Thanks

A pivot table in Excel won't allow me to add more fields or move a field from
the column area to the row area. When I drag a new field or attempt to move
the field, the Excel status bar displays the progress bar and a message
"calculating pivot table report" but after about 1 or ...

I have an external data source, which in this instance is a CSV file.  I need
to modify its appearance.  So i linked the data into a sheet and wanted to
use a table style.  When i do this, it brings up an error DB saying it cannot
format unless the link is broken.  

I've read through many posts on this topic but I've not been able to
find a solution to my problem.
On one tab I have six columns of information (table_array.)  Column
"A" contains a machine name, Column "B" contains a fault name and

Hello. Every 3 months I have to run a report at work that lists all
employees, their title, department, and supervisor. I then have to separate
it into separate workbooks by supervisor and e-mail it out. I am looking for
an easier way to separate it into different workbooks by ...

I trying to determine the sum of nine numbers in    Row / Column  
I12,M12,Q12,u12,y12,ad12,ah12,al12,ap12,  minus the two largest numbers of
the nine.
Thanks

What formula to write on D column:
To show “fail” when there’s an  “a” or “x” on any column of A, B & C.
To show “pass” when only “b”, or “c” or “e” (not a or x) on A, B & C columns.
A    B    C    D

Is it possible to set a shortcut key to display special characters?
In word you can assign say ctrl>a to give you á (done from the insert symbol
option) is this possible in Excel?
Thanks

I made a schedule sheet of my own from a template here.
A thru H is my job information.
K thru ET is my gantt chart for the run dates.
How can I delete a job from A thru H without wrecking the gantt calculations

using this formula to find values in column H
=ISNUMBER(MATCH(D2,'[sheet2]Data list'!H:H,0))
my question is if instead of searching just column H i wanted to search
columns A through column BK how do i do that?