• 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.

Split the data into sheets

Abhijeet

Active Member
Hi
I have data i want to split the data in 3 sheets according the headers in particular sheets.So please tell me how to do this
 

Attachments

  • Template Macro.xls
    25.5 KB · Views: 10
Hi
I have paste expected result in attach file.Data sheet data is not fix so please give daynamic range
 

Attachments

  • Template Macro.xls
    27 KB · Views: 3
Hi Abhijeet,

Check out the attached file.

I have used a sql query method to bring in the data

Just press ctrl+q to run the macro
 

Attachments

  • Template Macro.xls
    48 KB · Views: 13
Hi Sathish it not work when i copy paste in this file data then its not work & it will take long time after run the macro.
 
Please change the coding if u can use advance filter then i thing good
 

Attachments

  • Template Macro (2).xls
    48 KB · Views: 2
Hi Abjijeet,

I could not find any issue with the macro.

Its working perfectly

could you explain what exactly it is not doing
 
Hi Abhijeet,

The problem may be the version of the excel you are using

Please let me know if you are using the same file I have uploaded or copied the code to a different excel file
 
Hi Narayan its work but if value in column I the paste in Basic sheet, same with If column J:N any value then that data paste in Enhancement sheet, Same with If Column O:Qany value then paste in Overtime sheet is this possible
 
Hi Abhijeet ,

Do you mean to say that the data should be transferred from the Data tab to the other tabs as follows :

Column I ---------------------> Basic tab

Columns J through N --------> Enhancement tab

Columns O through Q -------> Overtime tab

Narayan
 
Back
Top