Trying to automate this template. I know what I want, just not sure how to finalize the last couple of items. The goal is for the production team member to enter all the data in 'consumer template' and it will feed into the datasheet & end wall tabs (which I will lock the sheets once finalized). Right now they manually write the data on the printed version and someone types it afterwards (waste of time). I am getting the production person a tablet so that they can do enter the data at the production line table as they work.
1. I'm wanting to use a formula in the 'end wall template' tab so that it only pulls the rows with the rcc part numbers (column c) that contain the the following part numbers that have "......I33, I34, & I35..." to show up in the 'end wall template' tab.
2. How do I get the cells to show 'blank' in the datasheet & end wall template? Right now there isn't any data in the 'customer template' for columns AE through AI but the 'datasheet' sheet is showing "0.00" until I enter data into those fields. Other cells are doing it as well such as 'column z'