turtsmurt
04-07-2010, 09:57 AM
Can anyone please suggest the best way for me to combine 100 worksheets into a master sheet if the information is NOT in the same format in every sheet? I was given all of this information as text and converted it to Excel in order to analyze.
I am trying to combined all 100 sheets into 1 master sheet so that I can use a Pivot table with these column headings, Year, Month, District, Location Number, Count of Notices...
Here is an example of my worksheets...
This is the information in one of the worksheets...
DISTRICT0100Location1/20102/20103/20104/20105/20106/20107/20108/20109/201010/201011/201012/201001415335503301319385214143881421110621353010111114513114372315754164312 18111920131711
Here is another worksheet....
DISTRICT0700Location1/20102/20103/20104/20105/20106/20108/20109/201001136610317117219611569316306411214111132411433311521216641712181119917 221
Here is another one...
DISTRICT
1700Location1/20102/20103/20104/20105/20106/20107/20108/20109/201010/201011/201012/201001956079603446499561360241134184611064236502309111442131848147122815141 815216105211832119412734101
Thanks in advance,
Christine:dunno
I am trying to combined all 100 sheets into 1 master sheet so that I can use a Pivot table with these column headings, Year, Month, District, Location Number, Count of Notices...
Here is an example of my worksheets...
This is the information in one of the worksheets...
DISTRICT0100Location1/20102/20103/20104/20105/20106/20107/20108/20109/201010/201011/201012/201001415335503301319385214143881421110621353010111114513114372315754164312 18111920131711
Here is another worksheet....
DISTRICT0700Location1/20102/20103/20104/20105/20106/20108/20109/201001136610317117219611569316306411214111132411433311521216641712181119917 221
Here is another one...
DISTRICT
1700Location1/20102/20103/20104/20105/20106/20107/20108/20109/201010/201011/201012/201001956079603446499561360241134184611064236502309111442131848147122815141 815216105211832119412734101
Thanks in advance,
Christine:dunno