SOLVED

Fill in a table from a reference table with conditions

Copper Contributor

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 TableOverview TableDiesel TankDiesel TankDiesel Trailer 1Diesel Trailer 1Diesel Trailer 2Diesel Trailer 2

 

3 Replies
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.

@Arslannaz 

 

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.Irrelevant data marked in red.Screenshot 2024-05-13 at 12.05.00.pngScreenshot 2024-05-13 at 12.05.05.png

best response confirmed by Brigitte1670 (Copper Contributor)
Solution

@Brigitte1670 

 

Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?

1 best response

Accepted Solutions
best response confirmed by Brigitte1670 (Copper Contributor)
Solution

@Brigitte1670 

 

Apologies for mis-understanding in first place. Attached a workbook with forumula in place on "Diesel Tank" sheet. Please let me if it helps?

View solution in original post