Recent content by ajoshi76

The code on the original excel has been fixed and its working on the logic. Thanks for your time and patience.

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..

As per #13, there is no code for that sample excel..... thats what i wrote in #16... Hence, the excel is XLSX extension and not XLSM.

okay

I dont think the excel macro recorder will work and help. But this would be a good exercise for the VBA beginner.

No.... the code was for the original excel which doesnt work. For the simple Sample - didnt create as the code is roughly the same from the process perspective.

Attaching #8 Workbook.

This code doesnt work which i created... And i am unable to modify the code to make it work.... >>> use code - tags <<< Sub ICA_Process() Dim R_cnt, Rn_cnt, LR As Long Application.ScreenUpdating = False Worksheets("Form II").Select 'R_cnt = Worksheets("Form II").Range("C17").Value R_cnt =...

I know it wouldnt work as per the excel workbooks - the #8 was created to simplify the requirement.

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 : Table 1 Role Details Phase Employee Type # Location % IT Business Analyst Analyze Employee 1 India 100% IT Build Design Employee 1 London 25% IT Build Development Employee 2 India 100% IT Build Development Contractor 1 Poland 50% Functional Tester...

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 ?

can someone help?

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 : Impact Assessment Form II Sheet has the Unique Role & Phase Combinations listed in Column T & U ... The Count on T12 cells denotes the count of data...

The Logic is in the spreadsheet on how the data should be populated using Form II data and populating all the remaining spreadsheets. The data is populated for understanding the logic completely