ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need macros for copy data into new workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/200719-need-macros-copy-data-into-new-workbooks.html)

Hardeep_kanwar[_2_]

Need macros for copy data into new workbooks
 
Hi! Experts,

I want to copy the data of Column A. i.e. DBCode into another workbooks.
http://www.savefile.com/files/1755059

For example:
In Workbook1- sheet 1, nZ01, Sheet2,nz02 and so on
InWorkbook2-sheet1,cz01,sheet2,cz02 and so on
In workbook3-sheet1,sz01,sheet2sz03 and so on
In workbook4-sheet1,wz01,sheet2,wz02 and so on
In workbook5- sheet1,ez01,sheet2,ez02 and so on

Thanks in Advance

Hope to hear you soon


Hardeep kanwar




Ron de Bruin

Need macros for copy data into new workbooks
 
Maybe this will help you
http://www.rondebruin.nl/copy4.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hardeep_kanwar" wrote in message
...
Hi! Experts,

I want to copy the data of Column A. i.e. DBCode into another workbooks.
http://www.savefile.com/files/1755059

For example:
In Workbook1- sheet 1, nZ01, Sheet2,nz02 and so on
InWorkbook2-sheet1,cz01,sheet2,cz02 and so on
In workbook3-sheet1,sz01,sheet2sz03 and so on
In workbook4-sheet1,wz01,sheet2,wz02 and so on
In workbook5- sheet1,ez01,sheet2,ez02 and so on

Thanks in Advance

Hope to hear you soon


Hardeep kanwar





Hardeep_kanwar[_2_]

Need macros for copy data into new workbooks
 
Thanks sir
For your quick reply, but i totally stupid in Macro

Need more Details

Hardeep kanwar

"Ron de Bruin" wrote:

Maybe this will help you
http://www.rondebruin.nl/copy4.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hardeep_kanwar" wrote in message
...
Hi! Experts,

I want to copy the data of Column A. i.e. DBCode into another workbooks.
http://www.savefile.com/files/1755059

For example:
In Workbook1- sheet 1, nZ01, Sheet2,nz02 and so on
InWorkbook2-sheet1,cz01,sheet2,cz02 and so on
In workbook3-sheet1,sz01,sheet2sz03 and so on
In workbook4-sheet1,wz01,sheet2,wz02 and so on
In workbook5- sheet1,ez01,sheet2,ez02 and so on

Thanks in Advance

Hope to hear you soon


Hardeep kanwar







All times are GMT +1. The time now is 12:52 AM.

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