Question

[smpaz7467]

I am a civil engineer. I use excel to sort out different areas, setbacks, and various information for each lot. I have all of this data on 1 sheet by lot number. I am wondering if there is a way to have all of this data be seperated into individual sheets. Ex. All of lot 1's information would create it own sheet automatically and copy all information related to lot 1 from my main sheet to the new sheet. And then it keep making sheets for the rest of the lots. Is this possible and if so what would I need to do?

 

[smpaz7467]

Norie,

This is what I have for data in my spreadsheet. Now what I am looking for is take all of the data for lot 1 and make a new sheet within the workbook and paste all of this data in that sheet. Then it continue to do this for the rest of the lots. I dont have an exact number of lots for this to work with since it changes from job to job. If you need any more information let me know