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
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...
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...
The below code is executed after the shape (Gantt chart bar is created) to update the text (Task description).... The output is that from the left margin of the bar the task description is populated... But i would like to have the task description tagged after the bar is ended. I am attaching...
Hi All,
I have multiple sheet - having data in Row 2 starting from A2 until some columns (some sheets have data till D, some have data till G etc..)
I would like a macro, which would copy the data of Row 2 (All columns having data) from all sheets and paste it transformed in Column A in Sheet...
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
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
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...
Hi
I have 2 worksheets: Sheet 1 and Sheet 2.
Sheet 1 is the Master Db having Application Id, Environment Name, Milestones, Start Date and End Date. Each Application Id can have multiple environment and multiple milestones. Looks like this
Application Id Environment Name Milestones Start Date...
I have a workbook called "WB1.xlsx" which has multiple worksheets "WS1", "WS2" and "WS3".
Each worksheet has a common column called "Name"....
I am looking for a macro to split the data using the Name column into multiple workbooks.
The output should look like:
WB1: Master Workbook having...
Hi
I have 2 worksheets: Sheet 1 and Sheet 2.
Sheet 1 is the Master Db having Application Id, Environment Name, Milestones, Start Date and End Date. Each Application Id can have multiple environment and multiple milestones. Looks like this
Application Id Environment Name Milestones...
Hi
I am attaching the sample file. Columns and Rows can be "n" numbers.
The macro should pick the column A and paste it in the resultant table
And then each row based on the value "x" available it should put the column headers spaced by comma.
The columns could be infinite and rows could be...
Hi
I have a table as below:
App Id a b c d e
1 x x x x
2 x
3 x x
4 x
This table is not fixed in rows and columns
The resultant table is:
App Id Column Headers
1 a, b, d, e (this is where the "x" is)
2
3
4
Can you please help
I have created an excel file with dummy details..... like:
1. Name of the resource
2. Designation
3. Team Name
4. Name to link to Stencil (this should be used as reference to pick the stencil)
5. Line Manager
I have created multiple stencils based on City, Employee type (this name is the same...
Hello All,
I have a table having the following columns:
1. Assignee
2. Application Name
3. Month showing number of tickets
RAW Data is as below:
Assignee Application Name Jun Jul
Resource 1 Application 1 3 4
Resource 3 Application 3 160 132
Resource 3 Application 1 8 45
Resource 2...
I need to create cascading dropdowns using indirect function. and then based on these dropdowns charts should appear.
If drop downs are all, then all charts (miniature) should appear
If one dropdown is selected and rest are all then all charts related to that dropdown selection should appear...
Hello All,
I have a table having the following columns:
1. Resource Name
2. Month
3. Application Name
4. Ticket Id
Can anyone tell me how to find out the Top 3 Application Name for a particular resource for a particular month?
Hello All
I have been using Excel 2010 Sparklines and Slicers for creating Dashboards
Now at work unfortunately due to constraints I have been downgraded to Excel 2007
1. Is there a way to still work on Sparklines and Slicers for creating Dashboards?
2. Can i create an excel dashboard...