Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a macro to sort and export data to multiple worksheets
Hello,
I am a Network Administrator for an Investment Advisory firm that is using Excel 2003. On a daily basis, they download updates to their clients portfolios. This data can be exported to a CSV file from within the program they use to download the data. The exported data shows the portfolio code, as well as any updates to funds held in their portfolio. The entire client portfolio list is managed between three portfolio administrators, each one responsible for an equal amount of the portfolio list. They have a separate Excel Spreadsheet that has all of the portfolio codes in Column A and the Portfolio Administrator who manages that portfolio in Column B What they would like to do it take the Excel document that contains the portfolio code and daily updates for the client portfolio list and somehow split that one sheet into separate sheets containing the portfolio code and the associated updated data. This solution would need to move the entire row from the master sheet to the appropriate portfolio administrator sheet. Once split into three sheets, we will then save each portfolio administrator sheet separately and then import it back into the program they use to manage portfolios. The update worksheet would be created new daily, so I was thinking the best way to do this would be through an Excel Macro, but I simply do not have the knowledge necessary to write such a VBS Script. Any help would be greatly appreciated. Thanks, Sal DiPietro |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing macro to format multiple worksheets? | New Users to Excel | |||
help with macro to read and sort data from multiple text files | Excel Programming | |||
help with macro to read and sort data from multiple text files | Excel Programming | |||
sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
Help:macro to auto sort data to different worksheets... | Excel Discussion (Misc queries) |