Hi Brian,
thanks very much for your reply, both alternatives work fine. But if you
work with a lot of files, let`s say 20 - 50, to be combined and you have
to do that job once every 2 weeks it would be cool to find a more
effective way to do it. That is why I am looking for a way to kind of
automate this. The batch import was just one idea, because the files to
be imported will always be in one folder and will always have the same
names. I do not necessarily need all the data combined in one file, it
would also be OK just to import certain columns from the original files
to my main document. Is that somehow possible, maybe with a macro?
Kind regards,
Christian
Brian Barker wrote:
At 15:45 07/08/2008 +0100, Christian Liebig wrote:
I am new to this list and I hope this is the right place for the
following problem:
Very probably!
I have several Excel files, each containing 1 sheet. I would like to
combine them to 1 spreadsheet document where each file should be
converted to a sheet in the new document. All original files are in 1
folder so my idea is to do some kind of batch import but I have no
idea how to do that.
I don't know any batch facility. Unless you have too many files, try
one of these:
o Open your first document in Calc.
For each subsequent document:
o Select a sheet adjacent to where you want the next one to appear.
o Go to Insert | Sheet From File... .
o Browse to the next document file.
o Select Before or After current sheet under Position.
o Under Sheet | From file, select the sheet(s) of the new document
that you wish to insert. (You can select multiple sheets using
Ctrl+click.)
o Press OK.
Alternatively:
o Open your first document in Calc.
For each subsequent document:
o Open the document in Calc.
o Select the sheet you wish to copy.
o Go to Edit | Sheet > | Move/Copy... .
o Under "To document", select your main document.
o Under "Insert before", select your desired position for the insertion.
o Ensure that Copy (at the bottom of the panel) is ticked.
o Press OK.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Christian Liebig, PhD
FILM - Facility for Imaging by Light Microscopy
- Facility Assistant -
Sir Alexander Fleming Building, desk 403
Imperial College London / South Kensington
Exhibition Road
London SW7 2AZ
UK
Tel. +44-(0)20-759-49793
Fax +44-(0)20-759-43100
E-mail [EMAIL PROTECTED]
Website: http://imperial.ac.uk/imagingfacility
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
