Hi there,
I have a workbook that tracks projects by project# (CIR). A button runs a VBA module for NewProjects that prompts for a new (unique number) CIR, copies and pastes a new row into the "Project Summary" sheet, and copies a project details sheet from a template sheet and names it as CIR...