II am trying to create a macro to take certain data from a primary worksheet and create a 2nd worksheet that will act as a log of the first.
This is the primary worksheet:
Here is the log I would like to create:
Trader ID and Date are simply carried over.
I would like to automatically convert the Branch Codes into names for the GSP column.
Also, I would like to be able to have some way to input the appropriate information for the Violation type and the Date Sent columns of the log for the entries from the Primary worksheet.
Thank you in advance for any advice and help you can give me!
This is the primary worksheet:
Log In Macro HTML.xls | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | PrimaryColumns | |||||||||||||
2 | Trader_ID | Account_Number | Branch_Code | Security_id | BeginningPosition | EndingPosition | TotalBuys | TotalSell | TotalVolume | Volume | %ofVolume | TD | ||
3 | XXXX | 11111111 | AA | IBM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8/14/07 | ||
4 | ZZZZ | 22222222 | BB | IBM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8/2/07 | ||
Sheet1 |
Here is the log I would like to create:
Log In Macro HTML.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
6 | LogColumns | ||||||
7 | Date | GSP | TraderID | ViolationType | DateSent | ||
8 | 8/14/2007 | Smith | XXXX | MTC | 8/16/2007 | ||
9 | 8/2/2007 | Jones | ZZZZ | MTC | 8/16/2007 | ||
Sheet1 |
Trader ID and Date are simply carried over.
I would like to automatically convert the Branch Codes into names for the GSP column.
Also, I would like to be able to have some way to input the appropriate information for the Violation type and the Date Sent columns of the log for the entries from the Primary worksheet.
Thank you in advance for any advice and help you can give me!