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