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 have a sheet....

"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

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

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

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