VBA code for CopyPaste from on WKB to Multiple WKBs

[Ramesh Subrahmaniam]

There is one data entry workbook for each tool number where all the datas of the tool are entered, however we want the data to be stored as values separately in multiple workbooks designated by the Too Number. The cells are not in continuous in any row or column in the destination workbooks

 

[Luke M]

I suggest looking over some of the many example Ron has listed here:
http://www.rondebruin.nl/win/section3.htm
He's done a lot of great work with copy/pasting to different sheets/workbooks.

 

[Ramesh Subrahmaniam]

Hi Luke:

Thank you. The example Ron has at is site is good one and it is a good starting point for me to modify to suit my requirement.

I want to copy values from the source workbook into existing workbooks without creating new workbooks. The values are in a row but needs to be pasted in different cell in workbooks with name matching with the tool number.

Thank you,
Ramesh