title: What formula would I use to make a column automatically populate in excel when new data is loaded into a worksheet?
body: <p>I am creating a report in Excel with 3 separate worksheets, the main one where data is reported and calculated, one for new data and one for old data. I want values in one column in the main worksheet to update when new information is moved into the new data worksheet but still see values that were in the old data that may have dropped off the new list.</p>