demetre
06-11-2007, 10:18 AM
good afternoon Everyone
Excel 2003
Issue: i am having trouble coding VBA to combine ranged rows from multiple different worksheets and workbooks into a single Master workbook(which contains all 8 different templates) :banghead:
I have searched through the forums but i cannot find exactly what i need. I know it is very straight forwarded but it is evading me....:dunno
Process required:
Workbook contains 8 worksheet templates(not identical, but similar), which contain either numerical & financial or strings in cells (separate, not a mixture, either one or another) with a naming convention of every worksheet (8 alphanumeric characters) where the first 6 alphanumeric characters will indicate where the file has come from. The last two characters will indicate which of the 8 templates it is associated with. eg AA, BB, CC, DD, EE, FF, GG, HH (whole list btw).
Each worksheet is different, but only rows 2-6 will be required to be copied, there are multiple numbers of columns size(dynamic).
data: numerical & financial data (up to 12 digits) / strings (max 32 characts, but that is overkill)
8 Worksheet templates ==> 1 Master workbook, which will combine all this data
Master workbook would contain the following worksheets (AA, BB, CC, DD, EE, FF, GG, HH) using the the first 6 characters from the names of the worksheets, eg FG1XXXAA, where FG1 is a constant for each of these worksheet, XZX is who the worksheet(s) is from, and the suffix AA to HH as the type of template used and ready to be imported.
So in a nutshell i would like to setup a macro to
*copy rows 2-6 of every worksheet, but then
* copy using the naming convention from first 6 characters, and the last 2 characters to import into the respective master worksheet
I will be dealing with about 200-300 worksheets intially.:bug:
Any assistance would be very appreciated... thank you in advance....
Excel 2003
Issue: i am having trouble coding VBA to combine ranged rows from multiple different worksheets and workbooks into a single Master workbook(which contains all 8 different templates) :banghead:
I have searched through the forums but i cannot find exactly what i need. I know it is very straight forwarded but it is evading me....:dunno
Process required:
Workbook contains 8 worksheet templates(not identical, but similar), which contain either numerical & financial or strings in cells (separate, not a mixture, either one or another) with a naming convention of every worksheet (8 alphanumeric characters) where the first 6 alphanumeric characters will indicate where the file has come from. The last two characters will indicate which of the 8 templates it is associated with. eg AA, BB, CC, DD, EE, FF, GG, HH (whole list btw).
Each worksheet is different, but only rows 2-6 will be required to be copied, there are multiple numbers of columns size(dynamic).
data: numerical & financial data (up to 12 digits) / strings (max 32 characts, but that is overkill)
8 Worksheet templates ==> 1 Master workbook, which will combine all this data
Master workbook would contain the following worksheets (AA, BB, CC, DD, EE, FF, GG, HH) using the the first 6 characters from the names of the worksheets, eg FG1XXXAA, where FG1 is a constant for each of these worksheet, XZX is who the worksheet(s) is from, and the suffix AA to HH as the type of template used and ready to be imported.
So in a nutshell i would like to setup a macro to
*copy rows 2-6 of every worksheet, but then
* copy using the naming convention from first 6 characters, and the last 2 characters to import into the respective master worksheet
I will be dealing with about 200-300 worksheets intially.:bug:
Any assistance would be very appreciated... thank you in advance....