macro question with example file....

H

H.

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/exampleofproblem.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
 
B

Bryan Hessey

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

H.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top