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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a macro to sort and export data to multiple worksheets
You may want to look at these:
Ron de Bruin's EasyFilter addin: http://www.rondebruin.nl/easyfilter.htm Code from Debra Dalgleish's site: http://www.contextures.com/excelfiles.html Create New Sheets from Filtered List -- uses an Advanced Filter to create separate sheet of orders for each sales rep visible in a filtered list; macro automates the filter. AdvFilterRepFiltered.xls 35 kb Update Sheets from Master -- uses an Advanced Filter to send data from Master sheet to individual worksheets -- replaces old data with current. AdvFilterCity.xls 55 kb If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm sdipietro wrote: 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 -- Dave Peterson |
Reply |
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) |