Using find and copy, but only want it to search in 1st column

[Nikolette]

Hello all,

I'm using the macro below to search for a user-defined number in column A, and copy/paste only the rows that begin with that value into another sheet. The only problem is that it currently is looking in all of the columns for the user-defined number and copy/pasting the rows containing it, no matter which column the number appears in. How do I tell it to only grab the rows that have the user-defined number in column A?

Please Login or Register  to view this content.

Thanks so much,

Nikolette

[coreytroy]

Works for me as is.

[Nikolette]

A message box pops up and you put the number you want to look for...

[coreytroy]

Sorry just tested. Works OK for me as it is.

[Nikolette]

It works beautifully if column A is the only column that contains the number you're looking for...if it appears in any other column, it grabs those rows as well. I need it to only grab the rows that have the number at the beginning of the row, in column A...

[Nikolette]

Bump......

[AB33]

Nik,
You do not have a find/search function in your code.
What you have is a function to find the last non empty row in your data

Please Login or Register  to view this content.

You can use this line to find the last row in column A

Please Login or Register  to view this content.

But you will still have the same issue. I suspect the issue you have is this line which copies the entire row instead of limited columns.

Please Login or Register  to view this content.

[Nikolette]

Thank you, AB33...I do want it to copy the entire row, but only rows that have the given number in column A. I need a way to tell it not to look for the number in any column except for column A.

[AB33]

Try this line

Please Login or Register  to view this content.

[Nikolette]

That works perfectly! Thank you, AB33 :-)