Take data from worksheet to create a new worksheet

dspark

New Member
Joined
Jun 18, 2007
Messages
41
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:
Log In Macro HTML.xls
ABCDEFGHIJKL
1PrimaryColumns
2Trader_IDAccount_NumberBranch_CodeSecurity_idBeginningPositionEndingPositionTotalBuysTotalSellTotalVolumeVolume%ofVolumeTD
3XXXX11111111AAIBM00000008/14/07
4ZZZZ22222222BBIBM00000008/2/07
Sheet1


Here is the log I would like to create:
Log In Macro HTML.xls
ABCDE
6LogColumns
7DateGSPTraderIDViolationTypeDateSent
88/14/2007SmithXXXXMTC8/16/2007
98/2/2007JonesZZZZMTC8/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!
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top