First we have to delete several VB/macros in the #1 main highlight V14, and there control buttons as I will only be requiring 2 functions from the entire file, the ( Clear All , and the Highlight #1 )
Then we have to install the # 2 number generator.
Now the #1 main highlight V14 and the # 2 number generator run on 2 separate columns of data ,Red for the #1 main highlight V14 and Green for the # 2 number generator so that has to be adjusted accordingly ,
Once these parts have been completed then we have to end up with 37 of these along the page,
The #1 main highlight V14 for all 37 can be controlled by one button and one column of data,
the #2 number generator will have to be controlled by 36 separate columns of data ,I am not sure if the #2 number generator would require 36 separate buttons or if one can control all 36 at once this will be your call.
Once these bits have been accomplished I should then have 37 separate sets of data each numbering 36cells each that would have to be matched up against different levels of the data previously generated and a matching number comparison generated with a count of each .this VB/macros will have to be programmed
I am placing in an example in rows 10 to 17, columnAQ to BDY of what the #1 main highlight V14 should look like when it is loaded with data, the F to AO is included but that part is functional at present
.the red columns of data will control all 37 sections as it is all the same data,
The green columns of data is to control the 36 separate number generator, the first one does not require the generator
Why I say only 36 number generator are controlled by the green data because the very first section will not be controlled by the number generator as that data remains the same all other sections are constantly rotating.
2 威客就此工作平均出价 $78
Hello. Employer. I have read and understood the project. I'm interested this project. So, firstly I want to discuss with you about this project. Then I'll be happy. I wait for your good reply. Thanks.