G
Guest
Each week I receive a workbook from one of my customers. It contains mutliple
sheets with salesnumbers from all the branch of my customer. Each sheet
contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one
line in the sheets.
Each workbook are named "weeknr.xls" and are stored in the same folder.
Now my question/problem. I need to gather all sales info for one branch on
one article from all the weeks.
I know how to get the data from one workbook to another, but how do I get it
to scan all the workbooks in the folder.
Any ideas.
sheets with salesnumbers from all the branch of my customer. Each sheet
contains from 1 000 to 15 000 lines of salesdata. Every article sold gets one
line in the sheets.
Each workbook are named "weeknr.xls" and are stored in the same folder.
Now my question/problem. I need to gather all sales info for one branch on
one article from all the weeks.
I know how to get the data from one workbook to another, but how do I get it
to scan all the workbooks in the folder.
Any ideas.