You are trying to use your printout form as data entry form - and all your problems start from there.
Instead use data entry part as database. This means you enter data into (preferably defined) Tables following database rules as much as possible. Based on those Tables, you can then design any reports you ever want, and format them in any way.
Added is an example I gobbled together based on your workbook. (There was no way for me to find out what your data columns mostly were meant for, so I used dummy column headers for my attempt.)
You can register any number or projects there. When you select a project in report sheet, the info about selected project, and works and conditions linked with this project are displayed in report sheet.
|