bobby_793
03-27-2008, 01:21 AM
Dear All
First of all let me say thank to admin and his support team and other voluntary members who are doing a great job in order to helping people to increase their knowledge and solving their problems. I really impressed to join this forum. I am very new in VB i want to learn VB and that?s what i spending most of my time in this forum.
Here i have a small query.
1-I have 2 sheets this variance sheet b/w actual vs Budget. And variance stands in G. What i want to look values in G if grater than 1000 should copy to sheet 2.
2-Sheet 1 is vertical and sheet 2 is horizontal, so when it copy to sheet 2 base on horizontal.
Thanks in advance
Bobby
First of all let me say thank to admin and his support team and other voluntary members who are doing a great job in order to helping people to increase their knowledge and solving their problems. I really impressed to join this forum. I am very new in VB i want to learn VB and that?s what i spending most of my time in this forum.
Here i have a small query.
1-I have 2 sheets this variance sheet b/w actual vs Budget. And variance stands in G. What i want to look values in G if grater than 1000 should copy to sheet 2.
2-Sheet 1 is vertical and sheet 2 is horizontal, so when it copy to sheet 2 base on horizontal.
Thanks in advance
Bobby