R
Reader
Hello folks,
We decided to delete all rows on a worksheet that have Invoice Date as
today. I have two worksheets with invoices. One has invoice dates and
the other one doesn't. However, the same invoices are on both
worksheets. For some reason, the other worksheet is not supposed to
have Invoice Date and so it does not.
My question is: It is easy enough to delete all invoices having today's
date from the worksheet that has invoice date but how do I delete those
same invoices from the other worksheet that has no Invoice Date? Is
there a way to tell Excel to match up invoice numbers from the first
worksheet to the second and delete from the second as well? Or maybe I
can do some sort of lookup... Please help.
Thanks for reading.
We decided to delete all rows on a worksheet that have Invoice Date as
today. I have two worksheets with invoices. One has invoice dates and
the other one doesn't. However, the same invoices are on both
worksheets. For some reason, the other worksheet is not supposed to
have Invoice Date and so it does not.
My question is: It is easy enough to delete all invoices having today's
date from the worksheet that has invoice date but how do I delete those
same invoices from the other worksheet that has no Invoice Date? Is
there a way to tell Excel to match up invoice numbers from the first
worksheet to the second and delete from the second as well? Or maybe I
can do some sort of lookup... Please help.
Thanks for reading.