Reading an excel and filter data and add.

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

I have an excel say Book1.xls.
I will have data with 10 columns and 10 rows in it.
I will have another sheet in the same excel. I will have to update the second sheet with the information in the first sheet.
I will filter the columns based on my requirement.

Please help me get this.

Thanks in advance.
Thanks,
Swetha


1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
you can use Vlookup with referece to some unique details,

Could you put some data of your sheet so we can help you more efficiently.

Regards,
Rahul