Splitting data location wise from 3 sheets in 1 workbook

[Kalpesh93]

hi frds...

I have some queries in vba and m unable to find out the way...

I will try to explain as much as possible...pls check and give me solutions..

I have an excel workbook which contains raw data in 3 different sheets i.e. Sheet1, Sheet2 & Sheet3.

I want to split the data location wise from Sheet1, Sheet2 & Sheet3 in one workbook and that workbook will have all of that data from 3 sheets like Sheet1,Sheet2 & Sheet3.

I would like to split the data from Sheet1 in new workbook for a particular location (will name as "CHD") (Will name the sheet1 as "X"). Again I want to split data from Sheet2 for the same location (Will name the sheet2 as "Y") and the same activity should be done for Sheet3 (Sheet3 name as "Z"). All of the output from the 3 sheets should be saved in one workbook and eventually for all other locations.

Pls note *If any sheet doesn't contains any data for that particular location, lets say CHD location, contains data in Sheet1 & Sheet3 so in output file Sheets remains the same i.e. X , Y , Z (Even if the data is blank)

I am able to split the data from sheet1 in multiple workbooks for different locations but not able patch all those 3 sheets data for one particular location in a new workbook.

I have attached the raw data file...

Code which I am using to split the data:

Please Login or Register  to view this content.

[Kalpesh93]

Can any1 pls help me to out from this....
Pls help

[Kalpesh93]

Very disappointing,,, i thought i will get some help here....

[jaslake]

Hi Kalpesh93

I'm looking at it...don't give up the Ghost just yet...not as simple as it appears to be.

[jaslake]

Hi Kalpesh93

This Code is in the attached and appears to do as you require. Place the two Workbooks in the SAME Folder...matters not where. Open the Macro Book; you'll be prompted to select a raw data File (TEST_SAMPLE.xlsx). The Code creates (or empties) the Folder Locations where you'll find all the newly created Location Files.

Please Login or Register  to view this content.

[Kalpesh93]

@jaslake ...Thanks it works....thank you so much.....

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.