• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract from one sheet to different sheets

A

abdulncr

Member
Dear friends,


Could you please help on the below.


I would like to have VBA to extract data from one sheet to different sheets

my data in sheet Master A2:H2000. I wanted to extract the data in the range of A:I depends on the value in the coloumn H

I have created ten sheets with the value in coloumn H. for example if in the H value is DLB it is to go sheet DLB, if H value is DLS to go sheet DLS and so on.


Regards

Abdul
 
Abdul


If you had used the Google Custom Search box at the top of each page at Chandoo.org you will have seen these links:


http://chandoo.org/wp/2012/11/27/extract-subset-of-data/

http://chandoo.org/forums/topic/move-items-matching-certain-filter-criteria-to-another-sheet

http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/
 
Dear Hui,


Thanks for this. Second link is half suitable for me. this is extracting to different workbook. i wanted to extract in different sheets in the same workbook which already available with name of filtering value. Please advice


Thanks

Abdul
 
You must log in or register to reply here.
Back
Top