I have a table that has (Project Name),(Room),(Task),(Status). There are about 250 Tasks per Project that are the same for each Project. Just the name and the status will change in the table. How do I add a new Project and create a new table or add to a table with all the rooms and tasks the same but with a new Project name and the status set to (By Default) Incomplete. All Projects will have the same Data in them (Room,Task). I would like to do this with a "Create New Project" Button Macro, Enter name an then have it create the new table or add to a table.
I hope I explained it the right way
Any ideas