macro question with example file....
 

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:
http://members.home.nl/wo2propaganda...eofproblem.zip

Less than 30kb.

I have a table on a sheet called "input".
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 "input" sheet and put the
wanted results in a new "output" sheet.

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

What macro????

Any help is welcom!

Harry

macro question with example file....
 

Please...!?

Harry

macro question with example file....
 

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:
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:
http://members.home.nl/wo2propaganda...eofproblem.zip

Less than 30kb.

I have a table on a sheet called "input".
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 "input" sheet and put
the
wanted results in a new "output" sheet.

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

What macro????

Any help is welcom!

Harry


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=535611

macro question with example file....
 

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.