search for a product code, cut and transfer entire row to another sheet

[anilpatni1234]

Hi everyone,


I would like to create a box in sheet "Sales return" where I can enter a product code and press "search" button . (need to create search button as well)


When I press the "search" button then

* it searches that code in sheet "Invoice Data" in Range "F"
*Then, it cuts the entire row in which the value is present and transfers it to sheet "Sales return "

I would want it to search for next empty row and paste.


Is this possible??

I have attched my sample woekbook.

[Richard Buttrey]

I see no sheet called Sales Return.

Would you correct and manually add a copy sheet that shows the 'After' position which results from a product code selection. Be sure to note which product you have selected and where.

[anilpatni1234]

hey Richard,

I have attched the updated excel file.

Thank You.

[Richard Buttrey]

Will the Data ever contain more than one occurrence of a product code?

How do you use the information that gets applied to the Sales Return?
The way you're describing it, it seems that you're gradually selecting rows from one sheet and adding them to the other. So why not simplify this and just have an extra column on the Invoice Data sheet and autofilter the Data for the product in question and flag the cell in the new column for that item. Then remove the autofilter. When you want the information for the Sales Return just autofilter the data on the new column.

[anilpatni1234]

The product code is unique.
So it will never be repeated.


Right now I have a macro running on my excel file which automatically copies data from sheet "Invoice" to "Invoice data"

Right now the problem is that when a customer returns the product.

So when a customer returns the product then I just want to enter the product code so that it cuts the entire row from the "invoice data" and pastes it to "sales return".