Copy data from One workbook sheet to Another closed workbook sheet via VBA only
Posted on 2003-12-03
win 2000 sp4
Current Workbook name "OriginalData.xls
Current worksheet name "MyNewData"
Closed Workbook name "NewData.xls
Closed worksheet name "OriginalDataPost"
What I need:
Copy data from current worksheet to Another Closed Workbook worksheet.
However, Here is the tricky part....
Here is how I need to match up...
On "MyNewData" On "OriginalDataPost"
ColumnD to TO ColumnA
ColumnA TO ColumnB
ColumnB TO ColumnC
ColumnC TO ColumnD