Hi there!

I have the following problem:

I have an Excel workbook with 7 sheet: (i) Control (ii-vi) Case1, Case2, Case3, Case 4, Case5 and (vii) Output. What I would like to do is the following:

I want to copy certain rows for certain columns from the Cases1-3 (whereas Case 1 and 2 are mandatory and Cases 3-5 can be selected) to Output depending on the following entries in the Control sheet. The heading row for each block (one block is row(x) for Case1-5) is always taken from Case1. The fromat shall always be the same as the row has in Case1(e.g. date, number etc.)

Entries to be made:

- Case 3-5 are in E2-4, dropdown "yes/no" in F2-5 (if yes, include in copy; if no, do not include in copy)
- Heading Row definition in D2
- Start column definition in B2
- End column definition in C2
- Rows definition in A2, A3, A4 ......

Any idea?

Thanks!!!!! svm