Hi Guys,
I need to put Vlookup from one sheet to another. Please advise with VBA code
Hi Guys,
I need to put Vlookup from one sheet to another. Please advise with VBA code
Hi aleanboy,
You can do this without VBA.
If your vlookup is in sheet 1 and the data is in sheet 2, highlight the "range" of cells (data) in sheet 2 and create a named range.
Then in the vlookup include the "named range" in the formula.
If your not sure how to do this attach the spreadsheet (no sensitive data) and I'll do it for you.
Regards
peterrc
why do you need VBA for this? Why cant you just use the regular VLOOKUP()?
You need to suppl;y far more info for this.
what are you searching for
what is the range
which column to return
etc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks