How To Retrieve the Specific Columns data from multiple sheet to single sheet

[Sukhdev Singh]

Hi All,
Greetings for the day!
I wish to retrieve the data of column D in from all other sheet to Sheet one. Is there any way to retrieve it by formula or macro which can make it easy for me. Kindly Help.

Thanks,
Best Rgds,
Sukhdev Singh

 

[jayalaxmi]

vba will work

Pls go through this link

http://stackoverflow.com/questions/...column-data-from-multiple-worksheets-into-one

 

[Sukhdev Singh]

vba will work

Pls go through this link

http://stackoverflow.com/questions/...column-data-from-multiple-worksheets-into-one

Hi Jaya,
Thanks for reply. I have checked the linked but it is not working.
Thanks,
Best Rgds,
Sukhdev Singh

 

[Syedali]

PFA

 

[Sukhdev Singh]

Dear Syedali,
Thanks for providing the great help. this is the exactly I needed.
thanks once again.

Best Rgds,
Sukhdev Singh

 

[jayalaxmi]

PFA

hey ali what u had applied here can I know????

Regards,
Jaya

 

[Syedali]

hey ali what u had applied here can I know????

Regards,
Jaya

I did through VBA

 

[Syedali]

Dear Syedali,
Thanks for providing the great help. this is the exactly I needed.
thanks once again.

Best Rgds,
Sukhdev Singh

Most welcome. Don't forget to like..