Hi,
Wondering if someone could help me out. Eg below.
1.) I want to define a value. Ideally click on the cell that contain
this value and have this read as the value. i.e click cell (A1) - an
read 'apple' as the value.
2.) Search a range (A1:A5) for this value. Where this value exists, a
that row number, select another value from a different column (C?) an
paste to area within worksheet (E)
3.) Increment the rows where the pasting is going to build a list o
values.
Any help on the syntax would be greatly appreciated.
Many thanks.
Marcus
Eg:
A B C D E
1 apple 1 1
2 apple 1 1
3 pear 2 1
4 banana 3
5 apple
--
marcus7
-----------------------------------------------------------------------
marcus76's Profile:
http://www.excelforum.com/member.php...fo&userid=1518
View this thread:
http://www.excelforum.com/showthread.php?threadid=26814