Find and Move Help Please

[learner99]

Hi!
I'm trying to write a loop that will look at Row 1, check each cell until it finds the value "Textbox55".
When the Value is found it will copy that column to sheet2 column B.

Here is the rough version of my code so far..

Please Login or Register  to view this content.

[Leith Ross]

Hello learner99,

You don't need loops to do this in VBA. Here is the code to do it. This assumes your source is Sheet1 and the destination is Sheet2. The header column is copied to Sheet2 column "B".

Please Login or Register  to view this content.

[learner99]

That was perfect! Thank you.
I had to adjust the code alittle to get it to work.
Here is the code:

Please Login or Register  to view this content.

Thank you again!!!!

[Leith Ross]

Hello learner99,


You're welcome. I am glad the code was clear enough you could modify it for your needs.