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.

"ryguy7272" wrote:

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............





--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"project manager" wrote:

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