Delete a entire row based on a certain text in cell "B3"

Hey,

is it possible to delete entire row based on certain text in a cell "B3"?

Example:

If i type "A234" in cell "B3" - sheet " Return", then it searches for it in sheet "Invoice data" column "F" and deletes the entire row.
So I will write different text in cell "B3" and i want it to do the same as mentioned above.

is it possible?

With the help of Dabaho - Forum Contributor I have got this code. Thanks to Dabaho

Please Login or Register  to view this content.

However it says "Compile error: Invalid outside procedure"

Can anyone please help me

Originally Posted by anilpatni1234

If i type "A234" in cell "B3" - sheet " Return", then it searches for it in sheet "Invoice data" column "F" and deletes the entire row.
So I will write different text in cell "B3" and i want it to do the same as mentioned above.

is it possible?

Need to know data structure in "Invoice data".

Post a small sample workbook.

Hey jindon,

Here is the sample file.

SO basically " Invoice data" contains details of products sold. I get the details with the help of vba macro.

So when a customer returns a product then I want to enter the product code in sheet "Returns" - "B3" so that that can delete the details from sheet "invoice data"

Originally Posted by anilpatni1234

Here is the sample file.

Where?



Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

hey here is the sample file.

To "Return" sheet code module.

Please Login or Register  to view this content.

Hey Thank you so much. This is magic.
Is it possible to get a confirmation pop up message after we enter text in cell "B3" that "Are you sure you want to update?"

Or instead of worksheet change can we have the macro running with the click of a button?

....................

Hey jindon,

Thanks you so much.

Works wonders for me.
Thank you