How do fix the formating of certain cells using a formula pulling from another tab?
Hello,
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'
FULL-SHIPSET-TEMPLATE-DRAFT.xlsx
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'
FULL-SHIPSET-TEMPLATE-DRAFT.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I was expecting the formula to go somewhere other than column B and using column B as the reference.
The lookup to the Customer Template is the "Formula" section that I left out.
The lookup to the Customer Template is the "Formula" section that I left out.
ASKER
Rob....I'm not sure how to write the vlookup formula to pull the information that I want. I've added your formula to the cell (even thought I know it's missing the vlookup portion).
FULL-SHIPSET-TEMPLATE-DRAFT.xlsx
FULL-SHIPSET-TEMPLATE-DRAFT.xlsx
Sorry, you've still put the formula in column B so creating a circular reference because it refers to itself.
As noted before, I thought you were looking at putting the formula elsewhere pulling information based on values in column B.
As noted before, I thought you were looking at putting the formula elsewhere pulling information based on values in column B.
ASKER
I'm getting a circular reference error when I use the IF statement. I used the formula in 'end wall template' (column B). How does it know that I want it look up the data in 'customer template' (column C)? Also is there a way for it to not leave blank rows so that person doesn't have to go in and delete them since that sheet will be locked?
FULL-SHIPSET-TEMPLATE-DRAFT.xlsx