Quote:
Originally Posted by tomlam
Dear Sir
We would like to make a small programme which
copy some details from named "products details" file
into named "breakdown" file, the result will be as
named "breakdown-result" file
we will copy as follow steps
for "products details" file
for mark no : r1, we will copy the details from "products details" and paste into sheet 1 in breakdown file
for mark no: r2, we will copy the details from "products details" and paste into sheet 2 in breakdown file
|
Hi Tom,
Contrary to previous advice, the macro recorder will be of little use here and, even if it was, the code it produces tends to be very inefficient.
I've had a look at your
"products details" file and have some questions: Are the data always sorted by r1, r2, etc? Since your
breakdown file is empty, except for having nine worksheets, is there a reason you need to work with that rather than, say, creating a new workbook on the fly and adding worksheets as necessary?