Hello,
I was wondering if someone could help me. I am trying to capture a report that wil look as follows:
Date Homepage Advisor List UpvestList Upvest Calculator
What I need to do is fill the headings in with data from excel spreadsheets, however, this data is located in a worksheet, in a section midway the worksheet. Also, each day a excel workbook is created with this information. So I need to search through many directories, find the workbook, locate the section I am looking for and display the data in another worksheet with the heading specified.
Another problem is that each day of the month workbooks are created, then at the end of the month a new folder(the month name) is created and the new days of the month are added. Hope this all makes sense. My problem is that I do not know the best way to do this in excel, sql whatever. Can anyone tell me the best way. I heard a macro might be the best way but I have no idea how to create this.
Sam
I was wondering if someone could help me. I am trying to capture a report that wil look as follows:
Date Homepage Advisor List UpvestList Upvest Calculator
What I need to do is fill the headings in with data from excel spreadsheets, however, this data is located in a worksheet, in a section midway the worksheet. Also, each day a excel workbook is created with this information. So I need to search through many directories, find the workbook, locate the section I am looking for and display the data in another worksheet with the heading specified.
Another problem is that each day of the month workbooks are created, then at the end of the month a new folder(the month name) is created and the new days of the month are added. Hope this all makes sense. My problem is that I do not know the best way to do this in excel, sql whatever. Can anyone tell me the best way. I heard a macro might be the best way but I have no idea how to create this.
Sam
