Hello Evoxfan:

The summary row, is it always the last row of data?

Do you prefer the totals to be formulas or values? Values take up less
space in a workbook.

Do you want to store the source sheet and the generated budget report
in the same workbook (separate from the original, of course) or just
the generated budget?

Rows 1 to 6 are to be discarded?

How many worksheets do the source files contain and which sheet
contains the data?

Do you want the budget file to contain all generated budgets or just
the current one? (macro will either add a new workbook or worksheet)

You mentioned that blanks in the Section column should be ignored,
does that mean the other columns for the same record will also be
blank, or is the data in each column independent of the other? If we
ignore blanks (assume - remove) the number of rows in each column may
change and data displaced.

Material/Labour - is it possible that there is a value in both the
Cost and Sub Cost columns? Which takes priority? Should they be summed
in those instances?

Other - how are "remaining" costs determined? are these costs that
don't meet the Material/Labour criteria?



I've a macro that performs similar tasks, I'll tweak it this weekend,
based on your responses, to suit your requirements and you can test it
out on a sample book.


Steven