picking data from another table

[mani_singh]

hi everyone,

i have a problem in that i need a macro command to:

go to a table called "tier control" and copy some data into a table called "datatable"

- on "datatable" i input a value into column B, this value needs to be found in the table on "tier control" column A

- it then needs to copy from that table row cols A,D,E and F.

- and copy them into the "datatable" row originally typed into with the first value

- in the row the data must go on cols O,P,Q and R


and thats it!

i hope someone can give me a hand with this prob!

thanks

 

[ravishankar]

Hi
Paste the following codes in the macro window ( Alt F11)

sub tranfer()
x= worksheets("datatable").cells(rows.count,2).end(xlUp).row
y= worksheets("tiercontrol").cells(rows.count,1).end(xlUp).row
for a = 1 to x
for b = 1 to 4
c = choose(b, 1,4,5,6)
d= "A1:A" & y
worksheets("datatable").cells(a,b+14) = application.worksheetfunction.vlookup(cells(a,2), worksheets("tiercontrol").range(d), c,false)
next b
next a
endsub

run the macro
Ravi

 

[mani_singh]

didn't quite work, thanks for the try

just got errors from code