Trying to create a VBA in excel

[txgiang]

Hi,

I'm trying to create a VBA script in excel that will take the following excel spreadsheet which i attached and extract the following data into a new worksheet into the following columns: Name, Account, Cash total, Fixed Income Total, Income Trust Total, Canadian Equities Total, and U.S. Equities Total. Hoping someone can help me out or direct me to a solution.

Thanks
Thanh

[Speshul]

I recommend using the the Macro Recorder to record yourself manually performing these functions first, and examine the code (ALT+F11)