Previous Topic Next Topic

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

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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses
Excel function question
1234ah -
ac3mark -

3 responses