Find Value In Column & Copy Entire Row

Re: Copy Rows Between Sheets

Try this:

Sub Macro1()
Dim Ib As String
Dim rFound As Range
Ib = Application.InputBox("Enter Catalogue number", "Catalogue Number", , , , , , 1)
   rFound = Cells.Find(What:=Ib, After:=ActiveCell, LookIn:=xlFormulas, LookAt _
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False).Address
        Range(rFound).EntireRow.Copy Destination:=Sheets("Report").Range("A65536").End(xlUp).Offset(1, 0)
End Sub

Re: Find Value In Column & Copy Entire Row

You didnt explain that catalogue numbers were made up of Characters and figures!!!
try replacing:

Ib = Application.InputBox("Enter Catalogue number", "Catalogue Number", , , , , , 1)

with:

Ib = InputBox("Enter Catalogue number", "Catalogue Number")

Re: Find Value In Column & Copy Entire Row

Works for me

Re: Find Value In Column & Copy Entire Row

copying the whole row of the cell onto a new worksheet

I don’t think you mean a “new” worksheet, but an existing worksheet, namely sheet1, “Sales”

Why are you comparing the value entered in the Inputbox to sheet2 columns G,H and I?

Attached are two files.

The first has a button on Sheet1 to call an inputbox per your request.

The second file is a suggestion. Select a cell in column A of the Sales sheet then select a Catalog Number from the drop down box. (Notice there is a “Cancel” item in this list to cancel a previously entered Number.)

I notice you have at least one Catalog Number entered twice. The second file will allow selecting any duplicate Catalog Numbers, but you can’t see the other information about the Number to help make a decision as to which Number to select. (You can't do this with an inputbox.)

In general, duplicate numbers are an invitation to problems in your code down the road. I would suggest a suffix to the number to make them unique.

E.G.
F-530SA
F-530SB

Another way to select Catalog Nubmers is to use a single Combobox on the Sales sheet. The drop down list in the Combo box could show all or selected information about the Catalog Number.
It would work like a combination of teh two attached files.

Re: Find Value In Column & Copy Entire Row

Attached is another sample file using a checkbox and combobox on the sales sheet.

To add items to the order select a product from the combo box drop down list.

To insert an item click on the insert check box, select the ordered item row were you want the insertion, then select the item to insert from the combobox drop down list.

To cancel an item, select it, then select the cancel item from the combobox drop down list.