improting data in excel 2003
 

Hi,
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 of these
fields.
thanks in advance

improting data in excel 2003
 

If by "fields", you mean columns, there are a couple of options:

1. Copy each of the 19 columns separately.
2. For each workbook, delete the columns you don't want, copy the remaining
columns, then don't save the original. That will get you the data you want, and
preserve the originals.

--
Regards,
Fred


"kate_gaz" wrote in message
...
Hi,
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 of these
fields.
thanks in advance