how to copy some information from one excel file to another excel file
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
|