Forum Discussion
Solved
Fill in a table from a reference table with conditions
Hi, I am relativly new to excel and I am hoping someone can help me solve the following: I have an overview table with all the details about our Diesel Usage including the Diesel Tank and 2 F...
Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?
Simple type =(REF) your reference should be cell from where you are getting values in overview sheet. Drag it down in individual table cell and this will get all data automatically filled in individual sheet when data entry will be made in overview sheet.
Thank you.
I referenced all the columns in individual tables. How do I exclude the data not relevant to specific table? In other words if no Values have been entered in column F,G and or H in the individual tables.
Irrelevant data marked in red.
Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?