how to make data together by VBA

  • Thread starter Thread starter KONGSIR
  • Start date Start date
K

KONGSIR

i sent worksheetbooks to my workmates, with title line like this:
"NO.,name, gender, project name, finish date, price" and so on, they fill
the worksheet and then sent back to me. i kept all the files they sent back
in a fold named "all data" i have to copy all the data to a new workbook and
save it as "original data".xls. the problem is i dont know how much files
they would sent back, maybe some one won't sent back, and i dont have regular
names of the files, and in each file, the data may be not just one row, maybe
several rows. how could i do this job in VBA? because i have to do this job
several times a month, it waste me a lot of time. thank you very much!
 
You would want a looping macro to either make a formula in the destination
file for each or open each and copy the info from the source file(s) to the
destination file. More info needed.
 
Dear Don ,Thank you very much!
let me clearfy it : some .xls files in a folder, with the same title line
and format. but the number of the .xls file is uncertain, maybe 3, maybe 4 or
maybe 36. and the name of the .xls files are not regular. the data in the
..xls files are not uncertain too, maybe 3 line, maybe 4 line, or even more.
now i want to make all the data in one new file.
so what i want to do is " open each and copy the info from the source
file(s) to the
destination file."

Thanks again for help!
 
I did this for a client a few days ago.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


Send destination file and two sample source files.
 
Back
Top