Without using a macro, I am wanting to completely move, not filter, information from table 2 located on the sheet called '2022 trial calendar' to a NEW table with the exact same headers if column w on table 2 has one of 10 words in it. This new table (table 5) would be on a new sheet (sheet1).
the 10 words are:
Plea
Dismissed W/O Prej
Dismissed W/Prej
Jury
Bench
Mistrial
Plea/Sentence
Sentencing
Civil Commitment
FTA
These words are located on the 'data validation' sheet and listed in cells b2-b11 if this helps shorten a formula.
Is this possible?
If so how? I can upload the document if I must, but I'd prefer if I don't have to.
the 10 words are:
Plea
Dismissed W/O Prej
Dismissed W/Prej
Jury
Bench
Mistrial
Plea/Sentence
Sentencing
Civil Commitment
FTA
These words are located on the 'data validation' sheet and listed in cells b2-b11 if this helps shorten a formula.
Is this possible?
If so how? I can upload the document if I must, but I'd prefer if I don't have to.