Copy from open excel sheet and paste into close excel sheet

Hi:

I have attached excel files for referance

I need certain data from (Source File ) 10_2010_Store#1_DailySales to be copied into files
This is Open excel file and VB script can be in this sheet:

Destination Files - closed excel file ( i have all 31 blankfiles)
10-1-10_Store#1_REG1
10-2-10_Store#1_REG1
10-3-10_Store#1_REG1
10-4-10_Store#1_REG1 and so on until

10-31-10_Store#1_REG1.

Data need to be imported from 10_2010_Store1_DailySales


P119:Q178 into 10-1-10_Store#1_REG1 at A2:B61
T119:U178 into 10-2-10_Store#1_REG1 at A2:B61
X119:Y178 into 10-3-10_Store#1_REG1 at A2:B61

and so..(FYI : every 3rd Column data)

Let us try just for 2 files for now and then we can implement for full month.

FYI : I need to restore my daily receipt since the server they were in had crashed and i have lost daily receipts.

Please let me know if you have any questions.

Help is greatly appreciated..

Thanks...
RM

You can't copy to a closed workbook.

There's no indication how the daily sheets relate to the master

Try this,
Unzip all the workbooks and save into one separate folder, after you have adjusted the code in Module2 to the proper path,
click the button in the store sales sheet,

Hi RM,

You are copying to A2, not A2: B61

Bolded text shows the additional code

Please Login or Register  to view this content.

I suppose some more manipulation is required, this is why I went with the helper sheet in the first place, I forgot to add the sort part though

Please Login or Register  to view this content.

Hi Dave :

FYI:
List sheet has following file names in order:
10-1-10_Store#1_Z1_REG1.xls
10-10-10_Store#1_Z1_REG1.xls
10-11-10_Store#1_Z1_REG1.xls
10-12-10_Store#1_Z1_REG1.xls
10-13-10_Store#1_Z1_REG1.xls
10-2-10_Store#1_Z1_REG1.xls
10-3-10_Store#1_Z1_REG1.xls
10-4-10_Store#1_Z1_REG1.xls
10-5-10_Store#1_Z1_REG1.xls
10-6-10_Store#1_Z1_REG1.xls
10-7-10_Store#1_Z1_REG1.xls
10-8-10_Store#1_Z1_REG1.xls
10-9-10_Store#1_Z1_REG1.xls

RM

Check it again, in post #11