The macro is called PLXO extract; it is meant to reorganize data that is pasted into excel from another system. The error is created by a certain type of transaction which is categorized in the "Activity" column. Typically, activity types are one word "BOT" "SOLD" "JNLED", but one activity type, "SJ +" causes the macro to fail because there is a space between the "SJ" and the "+". I need to write in some code that creates an IF function to account for this situation. Firewalls wont let me attach to this thread. I have copy/paste a sample of the data that is pated to excel prior to the macro being run. I apologize for the inconvenience. Just copy/paste into your own excel window and run a text to colums, delimited with "space" checkmarked- uncheck "tab"- and finish (be sure to add a blank column to the left of the data and a blank row above to make it work properly--- e.g. data should start on the "B2" cell prior to macro) . Sorry again, I know it is a hassle. THANK YOU

Here is the VBA code:

Please Login or Register  to view this content.
G A I N A N D L O S S S U M M A R Y 1/10/2014
PLXSN44 D E L E T E L O T S 15:16:43

ACCOUNT: 123-456789 PLX POS: 0 RTA POS: 0

TRADE DT TXN QUANTITY PRN/OPT PREMIUM PRICE NET AMT
REF NMBR TYP DESC CUSIP/SYM UPDT DATE USER ID
_ 10.000 10.00 2013 SJ + 10 0 100 1000
SOLD GOOGLE INC-CL A GOOG 1/1/1900 SYSTEM
CS BUY COST ADJ. 0 SELL COST ADJ. 0 CVR C
_ 10.000 10.00 2013 SJ + 10 0 100 1000
SOLD GOOGLE INC-CL A GOOG 1/1/1900 SYSTEM
CS BUY COST ADJ. 0 SELL COST ADJ. 0 CVR C
_ 10.000 10.00 2013 SJ + 10 0 100 1000
SOLD GOOGLE INC-CL A GOOG 1/1/1900 SYSTEM
CS BUY COST ADJ. 0 SELL COST ADJ. 0 CVR C
_ 10.000 10.00 2013 SJ + 10 0 100 1000
SOLD GOOGLE INC-CL A GOOG 1/1/1900 SYSTEM
CS BUY COST ADJ. 0 SELL COST ADJ. 0 CVR C


F1=HELP F3=EXIT F7=BKWD F8=FWD F12=CANCEL F14=DELETE