I have a worksheet with 76 tabs of zip code information. Some of the tabs have the zips as text, some as numbers, some tabs have just a cell popoulated with info saying that no census is available. Is there any shortcuts that anyone could suggest that I could use to make one worksheet that contains the information from all 76 sheets with only zips and somehow drop all the stuff like "no census is available" and also have the zips all in the same format. Much obliged. If this helps that info I want to keep is always five characters long (zip code)
Michael
Michael
