Sheet containing 3000 Raws with various field i.e. Name of the party, TIN Number, Status, Basic,Vat, Add.vat, Total
first I filtered five Parties then use copy command and pest in Status field(column) with "Multy Invoice" in selecting filtered Raws,
then result showing all the Raw which are...
I HAVE 3000 LINE ITEMS CONTAINING VARIOUS COLUMN I.E.
NAME OF PARTY TIN NUMBER STATUS BASIC VAT ADD VAT TOTAL
FEW PARTIES ARE APPEARING MORE THEN 2 TIME
WHEN I FILTERED 5 PARTY AND REPLACE STATUS WITH "MULTI INVOICE PARTY"
THEN ALL THE RAW WHICH I HAVE NOT SELCTED , ARE REPLACE WITH "MULTI...