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?

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

On Jul 13, 5:26 pm, M&M wrote:
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?

Thanks alot Pete appreciate it!


"Pete_UK" wrote:

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

On Jul 13, 5:26 pm, M&M wrote:
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?

You're welcome - thanks for feeding back.

Pete

On Jul 13, 6:42 pm, M&M wrote:
Thanks alot Pete appreciate it!



"Pete_UK" wrote:
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

On Jul 13, 5:26 pm, M&M wrote:
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?- Hide quoted text -

- Show quoted text -