How to Copy particular column data

[gururajbc11]

Hi friends, I have a excel sheet which has 4 columns. ROLLNO, NAME, SECTION and MARKS. I just wanted pull only NAME column data. How can I achive this.
I appreciate the help.

Thanks,
Guru

 

[rsingh40]

HI Guru

using MS Excel VBO - Get Worksheet as Collection Offset.

In startCell give value as "B1".This will not copy data from column 1.

 

[VJR]

- Find the last row for the B column using 'Get Number of rows' into a data item say 'LastRow'
- Use 'Get Worksheet Range as collection' with parameter as "B1:B" & [LastRow]

 

[eaglebot]

@VJR you are Gold sir . Thank You