Code Aid please

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thanks alot Pete appreciate it!


Pete_UK said:
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
Click to expand...
 
Back
Top