Hi There.. I need some urgent assistance on excel.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Each Monday of every week I receive an excel workbook (automate extract from finance tool) with 8-10 worksheets (Worksheet name format = ‘ABC report 2011-07-25-21-40-06.xls’. What I need to do is;<o></o>
1. Extract just 2 worksheet from original workbook (column B and D)<o></o>
2. Delete rows & columns those are not required. <o></o>
a. Delete row ‘A’ as its empty<o></o>
b. Delete column ‘A’ and ‘B’ as those are empty<o></o>
c. Also delete column ‘D’. ‘E’, ‘F’ as those are not intended output<o></o>
3. Add five columns<o></o>
a. Each per region – ‘NA’, ‘LAC’, ‘EMEA’, ‘APAC’ and ‘Proability’<o></o>
4. Filter data in column ‘P’ (order date) from newest to oldest along with all other attributes<o></o>
5. All the columns should be ‘filterable’<o></o>
6. And the most difficult and time consuming is to identify what’s the new activity since the last report. (flag new rows from the last weekly report)<o></o>
7. Upload the output file into SharePoint.. Not sure if there is a possibility of uploading the raw data workbook in SharePoint first and maybe then run a code so that we can store the output directly on SharePoint. This might help us on point 6 that I mentioned above. <o></o>
Any help urgently is greatly appreciated..<o></o>
fficeffice" /><o></o>Each Monday of every week I receive an excel workbook (automate extract from finance tool) with 8-10 worksheets (Worksheet name format = ‘ABC report 2011-07-25-21-40-06.xls’. What I need to do is;<o
></o>1. Extract just 2 worksheet from original workbook (column B and D)<o
></o>2. Delete rows & columns those are not required. <o
></o>a. Delete row ‘A’ as its empty<o
></o>b. Delete column ‘A’ and ‘B’ as those are empty<o
></o>c. Also delete column ‘D’. ‘E’, ‘F’ as those are not intended output<o
></o>3. Add five columns<o
></o>a. Each per region – ‘NA’, ‘LAC’, ‘EMEA’, ‘APAC’ and ‘Proability’<o
></o>4. Filter data in column ‘P’ (order date) from newest to oldest along with all other attributes<o
></o>5. All the columns should be ‘filterable’<o
></o>6. And the most difficult and time consuming is to identify what’s the new activity since the last report. (flag new rows from the last weekly report)<o
></o>7. Upload the output file into SharePoint.. Not sure if there is a possibility of uploading the raw data workbook in SharePoint first and maybe then run a code so that we can store the output directly on SharePoint. This might help us on point 6 that I mentioned above. <o
></o>Any help urgently is greatly appreciated..<o
></o>
