http://www.mrexcel.com/archive/VBA/8653.html

It's going to be something like this:
Select a cell and then...
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC1,[TT_TIME.XLS]SHEET1!R1C1:R" &
cstr(rowcount) & "C8,8,FALSE)"

This is a great resources as well:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

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


"project manager" wrote:

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