thaofe051291
04-04-2017, 11:41 PM
Hello everyone, i'm new to excel vba and have no experience in using any excel vba / macro functions.
I am seeking advice from you guys
In "Sheet 1" I have the following data :
in column A =
A1 : AAAA
A2 : BBBB
A3 : CCCC
A4 : DDDD
A5 : EEEE
A6 : FFFF
(all of the value in column A are string)
in column B =
B1 : 1
B2 : 0
B3 :
B4 : 0
B5 :
B6 : 1
(only integer
I want to filter those data in "Sheet 2" with the following conditions :
If column B = 0, then the data on column A will be written in Sheet 2
so, BBBB and DDDD will be written in Sheet 2
How to make the vba / macro code if I'm using excel 2010?
Thank you so much for your help
I am seeking advice from you guys
In "Sheet 1" I have the following data :
in column A =
A1 : AAAA
A2 : BBBB
A3 : CCCC
A4 : DDDD
A5 : EEEE
A6 : FFFF
(all of the value in column A are string)
in column B =
B1 : 1
B2 : 0
B3 :
B4 : 0
B5 :
B6 : 1
(only integer
I want to filter those data in "Sheet 2" with the following conditions :
If column B = 0, then the data on column A will be written in Sheet 2
so, BBBB and DDDD will be written in Sheet 2
How to make the vba / macro code if I'm using excel 2010?
Thank you so much for your help