Forum Discussion
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 Fuel trailers.
Then I need to fill individual tables for the tank and trailers containing overview columns A,B,C,D,E and (G,H,I) or (J&K) or (L&M), depending on which diesel source table is being filled, and column N, O, P.
Is there a way to automatcilly fill in the individual tables.
For example when a value is entered in column G, H or I the Date, Reg No., Vehicle, Driver, Start Hrs, Farm, Section, Work Done & Balance will automatically be entered in those columns in the Dieseltank table?
Overview TableDiesel TankDiesel Trailer 1Diesel Trailer 2
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?
