Create workbook for data export and then data import?
 

Hello,

I have a workbook (book1.xls), which I share with a co-worker. Both of us
use this workbook for data collection on alternating weeks. The problem I
have is the workbook file size is 16MB and when zipped 2.5MB. This is a pain
as we have to e-mail this back and forth on a dial up modem.

1) I want to export the new collected data to a new workbook. with the new
workbook name referencing the original workbook name and todays date.
2) E-mail the exported workbook to my co-worker and he would import it into
his copy of (book1.xls).

Book1.xls Consists of:
3 worksheets (Sheet1, Sheet2, Sheet3)
Data needed to be exported is contained in ("B2:CW2") in each sheet.

Can anyone Helpme?

Thanks, Kevin Graham