Search results

Hui, Vletm, Attaching a better version of the template i am working on. Hope this clears all the issues related to data quality and selections and other related fields. 1) Sheet "Form" : The Components list box to be populated with the values from "Global Config" sheet using FC_List and its...

Thanks vletm ... The dataset was just a sample - i apologise if i have created incorrect dummy values :( I am currently working on a template which then would require automation. Could i get back to you and hui on this thread in a couple of days.

Thanks Hui... I am working on an entire template for automation - would need you to help me if possible. shall upload the template tomorrow.

Thanks Hui - i am using excel with Mac - unable to customise the form - any idea how to do it?

Hello I have the following parameters which should be checkbox or a way to have multi - selection Application : A1 to A8 Location : L1 to L7 Role : R1 to R7 Features : F1 to F3 Components : C1 to C5 * Components are dependant on Features * every Role can have multiple location selected The...

Hi I would like to download all data from JIRA into Excel. 1. Front-End UI should have Username & Password 2. JQL Query Once its extracted, need a dashboard for analytical with also showcasing hierarchy based on Parent Child Links n JIRA. Please help Thanks & Regards Ashish

ok thanks

Hi Looking for a VBA Macro to be able to extract data from Odyssey or JIRA to Excel - all data with the data from the history tab and other data fields properly formatted etc. Thanks Ashish

thanks deepak; appreciate your help.

Hello I am attaching the source file and the final files i get after the macro is played. Book1 is the source file which has the macro. M1 to M4 is the split workbooks based on the macro. Couldn't attach the remaining created by the macro. 1. I dont want to lose any formatting in Consolidated...

I am unable to send the sample workbook as its against my company's legal policies. I will try and do something from home and upload.

Yes, understand that it takes column 2. i have changed in to column 4 but still it goes to DONE DONE DONE without splitting the workbooks

After having run the code multiple times i know what the functionality of the code. Workbook Details: The workbook has 5 sheets: Overview Stats Estate Milestone References The workbook has lot of macros other than the one we are currently wanting to create. Worksheet Details: Estate and...

The code goes to DONE DONE DONE without doing anything

What i meant was that we have a line of code stating : col_filter = 4 It take D1 as the filter to cut the data.... but the column header is on D4. Hence, the col_filter should consider D4 and not just column 4.

Quick : My Column filter is on D4. Hence, it doesnt let the code go ahead

Got it. I didnt use the code for AlphanumericOnly ... Let me check and revert how the code works.

Got it. I didnt use the code for AlphanumericOnly ... Let me check and revert how the code works.

"AlphaNumericOnly" Compile error: Sub or Function not defined

Great. Thank you Deepak. Appreciate

Its kinda urgent. But understand your situation.

The output should be : 1. Overview sheet (Full copied in every workbook) 2. References sheet (Full copied in every workbook) 3. App Level (Split in multiple workbooks per Column B values) 4. Environment Level ((Split in multiple workbooks per Column B values) 5. Milestone Level (Split in...

Further to the macro that was provided which works like a charm when all sheets needs to be split. I have a small modification request..... Attached is a new excel having 2 additional sheets "Overview" and "References". When the macro works. It should split the remaining 3 sheets as per what...

Hello I am attaching the workbooks in question. They have multiple sheets each. The sheet name are same in each workbook. I would like to consolidate all sheet by sheet in one workbook. So all Milestone sheet data should consolidate in Milestone sheet of new workbook and so on. Request you...

Fabulous... Thank you very much