Code Aid please

[Guest]

Hi,

What code should I use to have a Loop go through each cell in a range and
search for a particular value, then show that value in another sheet?

 

[Pete_UK]

By "code" do you mean VBA (macro) or will a formula do? The VLOOKUP
function will do what you ask, so you can build a formula around that.

Hope this helps.

Pete

 

[Guest]

Thanks alot Pete appreciate it!

By "code" do you mean VBA (macro) or will a formula do? The VLOOKUP
function will do what you ask, so you can build a formula around that.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thanks alot Pete appreciate it!






- Show quoted text -