software

Hi JMB and the others,

JMB, a few weeks ago you helped me with a macro. In a simpler form it worked
for me ok! Thanks!

I have a new problem now.

At this link is a small zip file with an xls included. In it, my problem is
described. I guess it must be simple, but for a beginner like me, it looks
difficult ;-)

download from:
members.home.nl/wo2propaganda...eofproblem.zip

Less than 30kb.

I have a table on a sheet called quot;inputquot;.
On this table some test conditions have been tested (by ordinary formulas
not included in the example workbook). This results in either false or true
results for TEST A, B, C etc.
False results are either 0 or an empty field. And the true results can
consist of any number over 0.

For reporting these tests, I have to process this quot;inputquot; sheet and put the
wanted results in a new quot;outputquot; sheet.

In my example file, I added a sheet in which a quot;handmadequot; output table is
shown. But this has to be done with a macro of course.

What macro????

Any help is welcom!

Harry
Please...!?

Harry

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

--H. Wrote:
gt; Hi JMB and the others,
gt;
gt; JMB, a few weeks ago you helped me with a macro. In a simpler form it
gt; worked
gt; for me ok! Thanks!
gt;
gt; I have a new problem now.
gt;
gt; At this link is a small zip file with an xls included. In it, my
gt; problem is
gt; described. I guess it must be simple, but for a beginner like me, it
gt; looks
gt; difficult ;-)
gt;
gt; download from:
gt; members.home.nl/wo2propaganda...eofproblem.zip
gt;
gt; Less than 30kb.
gt;
gt; I have a table on a sheet called quot;inputquot;.
gt; On this table some test conditions have been tested (by ordinary
gt; formulas
gt; not included in the example workbook). This results in either false or
gt; true
gt; results for TEST A, B, C etc.
gt; False results are either 0 or an empty field. And the true results can
gt; consist of any number over 0.
gt;
gt; For reporting these tests, I have to process this quot;inputquot; sheet and put
gt; the
gt; wanted results in a new quot;outputquot; sheet.
gt;
gt; In my example file, I added a sheet in which a quot;handmadequot; output table
gt; is
gt; shown. But this has to be done with a macro of course.
gt;
gt; What macro????
gt;
gt; Any help is welcom!
gt;
gt; Harry--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=535611gt; Rather than a macro (which you would have to remember to run, and keep
gt; checking the parameters) I would use a straight 'get' from the
gt; appropriate cell on the Input worksheet.
gt;
gt; Thus,
gt; in B14 put =input!B8
gt; in C14 put =input!G8
gt; in D14 put =input!K8
gt; and when all columns are set highlight all and formula drag to the end
gt; of your data.
gt;
gt; You can do the same with headings and totals etc, or simply type as
gt; required.
gt;
gt; This will give you an up-to-date output as per your input.
gt;
gt; Hope this helps
gt;

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.