Taking information from one worksheet and transfering it to another

Posted by Rich on October 26, 2000 12:43 PM

I have two worksheets in one workbook. I will refer to them as ws1 and ws2. WS1 is where I want my data to go. WS2 is where I want to get my information from.
Ws2 consists of 4 columns. I want to have a macro find the values in column A from ws2 on ws1. I then want it to enter the values from columns b,c and d from ws2 into the coresponding columns on ws1. I will be working on this. If you can help it would be appreciated

Posted by thomas venn on October 27, 2000 2:03 PM

instead of a macro, maybe you want to try Vlookup or Index(...(Match...)). check out the following discussion: 5198a.html

cheers,

thomas