thank you so much for the responses! I am going to try this immediately AND boost your reputation! Also, for Jmac1947...to be specific I am listing motors, there are tons of motors, but each one has a different name, but they all have the same inspection process. So I can create one spread sheet with all the fields I need for inspection and just re-use it over and over, etc OR, I can use this macro to create that inspection spreadsheet each time I type in a new motor name, and the sheet will be named after that motor automatically, and its just plug and play with the data at that point.