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?
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 Read More