Get value from cell to other sheet based on condtion [Closed]

Report
-
 Blocked Profile -
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 reply


Sheet references are stated as such: =Sheet1!B3

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!