Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros to copy and paste data Migyu Excel Discussion (Misc queries) 1 August 26th 08 01:25 PM
Copy/ move selected data from workbooks to seperate worksheets or workbooks Positive Excel Worksheet Functions 1 August 30th 07 04:54 PM
copy data from macros Bridgeton Excel Discussion (Misc queries) 1 July 9th 07 05:34 PM
Copy data across workbooks Copy multiple cells New Users to Excel 2 January 12th 06 12:20 AM
Copy data to another column Macros dominoguru2 Excel Worksheet Functions 2 November 2nd 05 08:01 PM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"