All,
My original spreadhsheet with user name, location and package is in this format:
[TABLE="width: 500"]
<tbody>[TR]
[TD]First[/TD]
[TD]Last[/TD]
[TD]Location[/TD]
[TD]Package[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]EX - RT CBOT, EXD - DELCOMEX, EXD - DEL NYMEX, NTWK WB BASE - QUOTES AG/COMMODITY, PUBLIC DEFAULTS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]EX - RT CBOT, EX - RT CME, EX - RT WINNIPEG, EXD - DEL COMEX, EXD - DEL NYMEX, NTWK WB BASE - QUOTES EN, PUBLIC DEFAULTS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]CASH MARKETS EDITION (PXCSH), , EX - RT CME, EX - RT EURONEXT ENCOM, EX - RT ICE (FORMERLY IPE), EX - RT ICE LIFFE, EX - RT MALAYSIA CPO, EX - RT NYBOT, EX - RT NYMEX, , LDP REPORTS (NPLDP), NTWK PRO BASE - AG/COMM EXD, [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I want to format the above spreadsheet so if Col - Package contain either words CBOT or COMEX or NYMEX or CME then i want a new sheet with following information
[TABLE="width: 500"]
<tbody>[TR]
[TD]First[/TD]
[TD]Last[/TD]
[TD]Location[/TD]
[TD]Package[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]CBOT[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]COMEX[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]NYMEX[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]CBOT[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]CME[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]Comex[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]NYMEX[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD]CME[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD]NYMEX[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for helping in this project
My original spreadhsheet with user name, location and package is in this format:
[TABLE="width: 500"]
<tbody>[TR]
[TD]First[/TD]
[TD]Last[/TD]
[TD]Location[/TD]
[TD]Package[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]EX - RT CBOT, EXD - DELCOMEX, EXD - DEL NYMEX, NTWK WB BASE - QUOTES AG/COMMODITY, PUBLIC DEFAULTS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]EX - RT CBOT, EX - RT CME, EX - RT WINNIPEG, EXD - DEL COMEX, EXD - DEL NYMEX, NTWK WB BASE - QUOTES EN, PUBLIC DEFAULTS[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD][TABLE="width: 350"]
<tbody>[TR]
[TD="class: xl65, width: 350"]CASH MARKETS EDITION (PXCSH), , EX - RT CME, EX - RT EURONEXT ENCOM, EX - RT ICE (FORMERLY IPE), EX - RT ICE LIFFE, EX - RT MALAYSIA CPO, EX - RT NYBOT, EX - RT NYMEX, , LDP REPORTS (NPLDP), NTWK PRO BASE - AG/COMM EXD, [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I want to format the above spreadsheet so if Col - Package contain either words CBOT or COMEX or NYMEX or CME then i want a new sheet with following information
[TABLE="width: 500"]
<tbody>[TR]
[TD]First[/TD]
[TD]Last[/TD]
[TD]Location[/TD]
[TD]Package[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]CBOT[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]COMEX[/TD]
[/TR]
[TR]
[TD]Andrew[/TD]
[TD]Wan[/TD]
[TD]Chicago[/TD]
[TD]NYMEX[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]CBOT[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]CME[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]Comex[/TD]
[/TR]
[TR]
[TD]Nicole[/TD]
[TD]Andy[/TD]
[TD]New York[/TD]
[TD]NYMEX[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD]CME[/TD]
[/TR]
[TR]
[TD]Ram[/TD]
[TD]Sinha[/TD]
[TD]Seattle[/TD]
[TD]NYMEX[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for helping in this project