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!
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Watch MrExcel Video

Forum statistics

Threads
1,122,233
Messages
5,594,963
Members
413,954
Latest member
mrsandy

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