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

that is
r1 paste to sheet 1 in breakdown file
r2 paste to sheet 2 in breakdown file

Then the result will be as name "breakdown-result" file

when we open the file "breakdown","products details" file,
how to write the the VBA code, then programe will automatically
copy and paste

sub a()

"HOW TO WRITE THE VBA CODE"

end sub

Thanks
Tom

Attached Files

	breakdown.xls (19.0 KB, 9 views)
	breakdown-result.xls (20.0 KB, 8 views)
	products details.xls (17.5 KB, 10 views)