okay. I attached the detailed excel showing output and inputs. i am not sure what is there to guess when the input and output are already given in so much detail plus attached an extremely simpleified version..
This code doesnt work which i created... And i am unable to modify the code to make it work....
>>> use code - tags <<<
Dim R_cnt, Rn_cnt, LR As Long
Application.ScreenUpdating = False
'R_cnt = Worksheets("Form II").Range("C17").Value
Workbook already attached in the first post ---- i tried to simplify it with the table... re-attaching the file. really need help in this. let me know if you need any information to enable you experienced people to help me please.
Let me make it more simple :
IT Business Analyst
Form II - Input sheet
Expected Result - Impact-Complexity Assessment Sheet
I have given the detailed expected result with the input worksheets having sdample data filled.
Not sure what are we looking for ?
Let me explain it thoroughly
The Data needs to be picked up from Form II Sheet and the 3 sheets need to be updated based on the below Logic :
Form II Sheet has the Unique Role & Phase Combinations listed in Column T & U ... The Count on T12 cells denotes the count of data...
I am looking for the Excel VBA if anyone can help me get this solved. I am trying to get the Data from Form II and using the correct logic update the 3 sheets.
Sample excel attached with all data and the easy it should update the various sheets.
Any help appreciate
Request your help in getting the ActiveBox ListBox populated based on 2 Validation lists and reference data in another sheet using Macro
1. Select Application Name
2. Select Feature Name
3. CLick on the Refresh Button - Populate the ActiveX ListBox based on 1. and 2. and Reference Data...
i have created a macro - which uses 2 excel based field values as filter to display the consequent result in ActiveX List Box.
In 1 machine - after the selections are correctly made and button is clicked the activex control display the results and when we select the content of the...
The VBA code should be in excel - and when the macro is run - it should have a DB connection to MS Planner application to upload the data from excel to Microsoft planner.
MS planner can read Excel files .