Sounds like homework; check out -VLookUp-
trishlee;455763 Wrote:
I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10
I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears
Is there a way that I can get the values from worksheet 1 to worksheet
2
without have to cut and paste each of the individual values?
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=126150