Hello,
I am creating an excel calculator where the user can download a report with set columns to paste onto one tab, that will feed though and calculate totals on another tab. The report (for arguement's sake) has columns A:F which do not change. The issue I am facing is that one column (column "C") does not have a value populated on every row. What I am looking to do is to put a formula in the calculator that will automatically fill empty cells with the value in the next populated cell beneath it. Column C may have 8 different values in it, each with a different number of blank rows in between. The formula populating the data may be in a new column. Any suggestions?