vlookup help

  • Thread starter Thread starter project manager
  • Start date Start date
P

project manager

i a sheet which i need to run vlookups on a change macro, i cant have it in
the cells because i need the cells to only have numbers no formula. sheet a
column c rows 2 to 184 have the task id in, columns d to j need to be
populated from sheet b column 4. however sheet b has other columns in
between which prevents a copy paste. column d = column 5, e= 7, f = 9, g=
10...

any help,

cheers
 
I'm trying to visualize what you're talking about, but can't quite get there.
If you want only values in your cells, sans formulas, or functions, you will
need a macro. If your work is not confidential you can send me an email and
I will try to do the code for you. Maybe someone else knows how to do what
you want to do............

(e-mail address removed)
 
sorry i cant send the sheet, can you explain how a vlookup works in a macro?

i think basically, if c and target row has a task number get the other stats
from the 2nd sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array VLOOKUP lookup_Value does not increment 3
Modify working code to expand the output. 5
vlookup 2
Lookup formula needed 1
Find a value in a sheet and replace it with another value if it matches 8
Array with many cells from a row but not in order or together 11
Somewhat complex code to copy data from one sheet to another 9
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26

Back
Top