I am creating a bid worksheet for my company. For certain jobs, we require more crews on site than we do for other jobs, so our number of crews needed changes per job. How can I input a crew cost table based on the number of crews needed for the job? I have attached my table so far for reference.
Basically, I would like to create a number of tables (A7:J16) based on the number entered into C5 with a one-row space between tables.
Also, would there be a way, once multiple tables have been created, to add the "Crew Total" cells and SUM(X,Y,Z) them into another cell?
Bookmarks