Search results

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

Hello All, 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 Thanks Ashish

Hello Hui The output (components) should be displayed in the Activex Listbox. based on Application and Feature combination.

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

Attaching the Sample file - It works on my machine and doesnt work on another machine

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

I wanted an automated code - not a manual upload - as it would be a project plan in excel which i wanted to auto sync with Planner. Manual upload doesnt solve my purpose.

The code should be executed via Excel - and then output should be validated and verified in Planner - both are microsoft products .

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 .

VBA to upload the data from the excel attached to Microsoft Planner application.

Hi, I am looking for a VBA to integrate excel table and MS Planner - Could one please help? Thanks and Regards Ashish Joshi