excel - Auto delete line -


i have create table of different operators, handling different vessel , having different code. want able auto delete table based on 1 operator on each worksheet (which have used macro copy paste on each individual sheet). kind of formula can use auto delete table lines in order keep data of individual operators on different worksheet?

ops    | ves name              | code cman     cma cgm vela cruz       017 cmans    cma cgm express         018 grand    nyk orpheus             036 msco     msc heidi               109 cman     cma cgm hydra           009 

if you're using excel, try selecting table, insert | pivottable , able hide table lines operators interest @ given moment.


Comments

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

node.js - Getting the socket id,user id pair of a logged in user(s) -

keyboard - C++ GetAsyncKeyState alternative -