Copy and Paste

[Double99]

This is my first post.. so thankyou to everyone who's taking time out to read my post and helping me with my problem...

I need a code that copies that data from Column A into Column C, if the value in Colunm B is '1'. If the Value in Column B is '0', then it does not copy anything into Colunm C and value in cell remains blank.

This needs to work throughout the entire colunm.

Example below....

A.............B...........C

T1............1...........T1

T2............0...........

T3............1...........T3

T4............0...........

T5............1...........T5

I think it needs VBA, as I can't work out how to do this in formula form. I've never done VBA before.

Thankyou

Cris

 

[Trevor G]

Welcome to the Forum Cris

Try using an If statement, no code required. see sample

Excel Workbook
	A	B	C
1	Check	Number	Result
2	T1	1	T1
3	T2	0
4	T3	1	T3
5	T4	0
6	T5	1	T5
7	T6	1	T6
Sheet6

 

[Double99]

Thankyou for all your help