Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to make data together by VBA
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to make data together by VBA
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! "Don Guillett" wrote: 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. -- Don Guillett Microsoft MVP Excel SalesAid Software "KONGSIR" wrote in message ... 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! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to make data together by VBA
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "KONGSIR" wrote in message ... 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! "Don Guillett" wrote: 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. -- Don Guillett Microsoft MVP Excel SalesAid Software "KONGSIR" wrote in message ... 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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using validation to make data appear or not | Excel Worksheet Functions | |||
How can I make graphs if without any data available? | New Users to Excel | |||
Can I make a data entry box? | Excel Discussion (Misc queries) | |||
How can I make categories out of my data? | Excel Worksheet Functions | |||
I don't know how to make a data table | New Users to Excel |