Split the data into sheets

[Abhijeet]

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

 

[Marc L]

Hi,

just test headers with If or Select Case statement …​

 

[Sathish KV]

Hi,

You may have to elaborate your query

Which is the header your need to split based on

 

[Abhijeet]

Hi
I have paste expected result in attach file.Data sheet data is not fix so please give daynamic range

 

[Sathish KV]

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

 

[Abhijeet]

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.

 

[Sathish KV]

Hi Abhijeet,

Could you please upload the new file

 

[Abhijeet]

I use 2010 version in that version get error in this line cn.Open strCon

 

[Sathish KV]

Any Error message?

 

[Abhijeet]

Now i m not use 2010 vesrion

 

[Sathish KV]

Please upload the file

 

[Abhijeet]

Please change the coding if u can use advance filter then i thing good

 

[Sathish KV]

Hi Abjijeet,

I could not find any issue with the macro.

Its working perfectly

could you explain what exactly it is not doing

 

[Abhijeet]

Hi sathish this is error showing please look & give me solution

 

[NARAYANK991]

Hi Abhijeet ,

Can you check the following on your PC , and post back ?

Check which ODBC driver is installed in your machine

Control Panel -- Administrative Tools -- ODBC -- Drivers Tab

There is a screenshot of what the above will look like here :

http://social.msdn.microsoft.com/Fo...alled-microsoftjetoledb40?forum=sqldataaccess

Narayan

 

[Abhijeet]

Hi Narayan i check this but i do not have access in company so please give me other coding of this

 

[Sathish KV]

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

 

[NARAYANK991]

Hi Abhijeet ,

I think it is better you don't use an SQL query method then ; use some other method.

Narayan

 

[Abhijeet]

Please tell me & give me macro in other method

 

[NARAYANK991]

Hi Abhijeet ,

See this file.

Narayan

 

[Abhijeet]

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

 

[NARAYANK991]

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

 

[Abhijeet]

Yes in this column any value then that row should be in particular tab

 

[NARAYANK991]

Hi Abhijeet ,

This is now understood ; it was not clear from your original post.

Give me some time.

Narayan