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

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

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
How to pull data from column based on multiple criteria?
Raj_2823 -
TrowaD -

3 responses
How do I change a base location on Instagram?
rebelkids -
38nancy -

8 responses