Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship.
In "Lines", there is a linked column back to sheet "AFE" which will only display AFE Numbers that have been added in "AFE" sheet's column called "AFE Number". Users only have access to the "Lines" sheet for data entry, they chooses the AFE, then enters a $$ amount.
What I'm trying to do is… in sheet "AFE" I want to total all rows available in the "Lines" sheet based on the AFE chosen in column Lines-AFENumber. The data in Lines isn't / can't be sorted due to the nature of how it's entered.
How do I write something like "In AFE-TotalUsed, sum totals entered in Lines-LineAmount where Lines-AFENumber = Sheet-AFENumber" ?
