Get value from cell to other sheet based on condtion

Closed
jas - Sep 28, 2016 at 07:14 AM
 Blocked Profile - Sep 28, 2016 at 04:56 PM
Hello,
i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex:


Cell A | Cell B
==============
AB |499
-------------------------
CD1 |399
----------------------
JK |233
------------------------
AB | 499
-------------------------
CD1 |399
----------------------
JK |233


this is my sheet with data now i want to get the column B data in my other sheet for ex:


Cell A | Cell B
==============
AB |499
-------------------------
CD1 | 399
----------------------
JK | 233
------------------------


1 response

Blocked Profile
Sep 28, 2016 at 04:56 PM
Sheet references are stated as such: =Sheet1!B3
0