Excel: Importing/copying data from another Excel file

[Horns]

I have some 700+ results from a market research i'm trying to gather into a single Excel document. Theres some manual input/tasks required for each so theres no 'easy' fix i'm sure, but what I want to do is have the bulk copied over automatically.
What, in practice, i'm hoping to do is [in my Results.xls]
Enter the manual data i.e username then 'hit a macro button'* which extracts data from another Excel document and transposes this data to the results spreadsheet. Anyone have any ideas how this can be achieved. I think i've got the workflow in my head - just cannot even begin to think how I would write any Macro - let alone a Macro to copy specific data from one file to another. Any ideas/help would be much appreciated.

Thanks

 

[SkipVought]

Hi,

Turn on your macro recorder and record the process of copy 'n' paste for ONE.

For help with VBA (macro) code, please post your quextions and recorded code in Forum707.


Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]