Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to run on the "Active Sheet" | Excel Discussion (Misc queries) | |||
Browsing/opening a file with a macro | Excel Discussion (Misc queries) | |||
Macro to Prompt for File -- Neophite Needs HELP | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions |