using macro, how can i copy similar fields from other xls files?

Shaji Valiath · May 23, 2006

I want to copy the similar fields from different excel worksheets and from
other excel files, to a single worksheet, so that organising all data
together. How can i perform this using Macro utility?

Norman Jones · May 23, 2006

Hi Shaji Valiath,

Ron de Bruin has some sample code at:

http://www.rondebruin.nl/tips.htm

See, for example:

http://www.rondebruin.nl/copy2.htm

and

http://www.rondebruin.nl/copy3.htm

using macro, how can i copy similar fields from other xls files?

Shaji Valiath

Norman Jones