ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   using macro, how can i copy similar fields from other xls files? (https://www.excelbanter.com/excel-discussion-misc-queries/90020-using-macro-how-can-i-copy-similar-fields-other-xls-files.html)

Shaji Valiath

using macro, how can i copy similar fields from other xls files?
 
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

using macro, how can i copy similar fields from other xls files?
 
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


---
Regards,
Norman



"Shaji Valiath" <Shaji wrote in message
...
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?





All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com