I am trying to get excel to create trade tickets as new Sheets based upon information I paste into sheet1. This information includes(In this order) Date, Account, Source, Quantity, Commission, FBSI Shortname, Amount, Txn Code, Txn Key, Symbol, Price, Interest Amount, Comments, Settlement Date, Broker, Cusip, Security Description, Security Type, Fund ID, Key Code, Core Fund, and TPA Order Guide.
I would only like to reference the date, acct #, Quantity, commission, FBSI Shortname, Amount, TXN Key, Symbol, and Price when creating the new sheets.
The trade ticket is already designed in sheet two 'MasterTicket':
Date (m/dd/yyyy)=D2
Price ($)=F5
Symbol (Ticker Symbol)=B6
Security Descript (Text)=C6
Acct#(AlphaNumeric)=A9
Txn Key=E5(In Large Caps if possible)
Type(#)=B9:B?
Quantity(# w/5Decimals)=C9:C?
Commission($)=D9:D?
FBSI Shortname(text)= E9:E?
Amount($)=F9:F?
At the bottom of the data is a row that totals the Quantity and Amount that needs to always be there.
Then I'd like to save each sheet as a seperate file named-
(YYYY)-(mm)-(dd) "Block Trading Form"(TXN Key)(Symbol)