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

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,903
Messages
5,834,309
Members
430,276
Latest member
legalcriminal015

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
Top