nidhipatel
Board Regular
- Joined
- Feb 11, 2017
- Messages
- 52
in sheet 1 Range A2 To A6 contins Student name lke
[TABLE="width: 105"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
STUDENT NAME
[/TD]
[/TR]
[TR]
[TD]Kalpesh Patel[/TD]
[/TR]
[TR]
[TD]Amit Shah[/TD]
[/TR]
[TR]
[TD]Vipul Rathod[/TD]
[/TR]
[TR]
[TD]Jigar Patel
[/TD]
[/TR]
[TR]
[TD]Hitesh Doshi[/TD]
[/TR]
</tbody>[/TABLE]
i wish to this data add in sheet2 range A2. and every time data add in last blank row in sheet2. this is made without copy & paste method. this is made by for loop vba only.
[TABLE="width: 105"]
<colgroup><col></colgroup><tbody>[TR]
[TD]
STUDENT NAME
[/TD]
[/TR]
[TR]
[TD]Kalpesh Patel[/TD]
[/TR]
[TR]
[TD]Amit Shah[/TD]
[/TR]
[TR]
[TD]Vipul Rathod[/TD]
[/TR]
[TR]
[TD]Jigar Patel
[/TD]
[/TR]
[TR]
[TD]Hitesh Doshi[/TD]
[/TR]
</tbody>[/TABLE]
i wish to this data add in sheet2 range A2. and every time data add in last blank row in sheet2. this is made without copy & paste method. this is made by for loop vba only.