Rather than a macro (which you would have to remember to run, and keep
checking the parameters) I would use a straight 'get' from the
appropriate cell on the Input worksheet.

Thus,
in B14 put =input!B8
in C14 put =input!G8
in D14 put =input!K8
and when all columns are set highlight all and formula drag to the end
of your data.

You can do the same with headings and totals etc, or simply type as
required.

This will give you an up-to-date output as per your input.

Hope this helps


Bryan,

As said, it would be to much work to, each time when a different report has
to be made up, to do everything by hand as you seem to propose. For every
report, other columns will be empty. For every report the Test conditions A,
B etc will have other values. So it has to be automated somehow so the
unwanted areas/colums will not end up in the reports.
Thanks for your answer and time!

Anyone else willing to have a look?

H.