Column Search for Data

NewExcelUser,

Here is how I handle a search for a specific piece of data. This is very generic and would need to be adapted to your worksheet.

Please Login or Register  to view this content.

Hope this helps!

Thanks for replying boylejob,

Can this code be modified so it is able to search not just for specific data, but any data in a specific column?

Incidentally, I just tried the code above using "Widget" as a search item. It does nothing if the item is found but says "not found" in the first available cell if it is not found. It is supposed to copy the found information over no?

Basically what I want to do is:

If any cell in column A <> " " Then copy the cells that <> " " to a different worksheet.

Sincere Thanks.

NewExcelUser,

Not knowing exactly what you were wanting to do, I just copied some code out of one of my programss to give you something to work with. I did not test it, but now that I look at it what it would do is find "Widget" on Sheet1 and then copy into Cell A1 of Sheet2 whatever was found in Column B of the Row on which "Widget" was found. Hope that makes sense.

Yes, the code can search for a variable which is basically what it is already doing. I just had it hard coded to give you a place to start. I am attaching an example spreadsheet which might make it a little bit clearer how the code works.

Hope this helps you get started!

NewExcelUser,

I'm sorry I missed the last part of your question. This code should do what you are asking.

Please Login or Register  to view this content.

This will look in Column A of Sheet1 and if the cell is not blank, it will copy the value to Column A of Sheet2.

I apologize for missing the last part of your last post and I hope is what you are looking form.

Hi Boylejob,

I appreciate the time you have taken to explain everything step by step in the example you attached, and the follow up code that you posted. It works flawlessly.

One question:
If I wanted to modify the code to start copying on row 2 and start pasting in row 2, how would the code be modified?

Thank you so much!

NewExcelUser,

Just in case!

In the code Cells(lrow, 1) the first item within the parentheses refers to the row number and the second item is the numeric representation of the column.

To switch this code so that it will look at Column Y

Please Login or Register  to view this content.

simply change the 1 to 25

Please Login or Register  to view this content.

I'm sure this is what you have already done, but I always like to follow-up.

I'm glad the code work and it was certainly my pleasure to be of assistance.