Copy from a certain range of an excel sheet and paste to another xls file?

Question

I'll try to explain.
I use Apple (if this could help)
I would like to create an automation that let me copy from a range in excel sheet (let's say from E44 to K48)
and paste the information in another excel sheet of another excel workbook.
In this last workbook, the information should be pasted on the next empty row.
I'm trying to create a long list from many short lists.

The best thin would be a drag and drop box where to drag all the files to process.

Answer 1

Hi,

I put a link to a great resource about automation in the sources below.

I'd start by turning on the Visual Basic Toolbar (View > Toolbars > Visual Basic). Turn the Macro recorder on and then go through the steps of selecting, then copying and pasting a range of cells. Turn the macro recorder off and see what was recorded in the Visual Basic Editor.

When in the Visual Basic Editor click on the Help button and search on
Getting Started

There's an amazing amount of stuff in the help system there.

-Jim Gordon
Microsoft Mac MVP

MVPs are independent and do not work for Microsoft
http://mvp.support.microsoft.com/