• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. ajoshi76

    MS Planner Integration

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

    Gantt Chart - Bar Text to be created after the Bar is over

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

    Copy Entire Rows from each sheet and paste it in another column in one column with Sheet name pasted against each field from where its being copied

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

    VBA for creating a table using the parameters from checkbox

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

    VBA Macro for JIRA

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

    Extract Data from Atlassian JIRA or Odyssey to Excel using VBA Macro

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

    Consolidate multiple sheets into a different workbook

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

    Min and Max dates using VBA

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

    Split multiple workbooks

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

    Finding Min and Max Dates using multiple filters without using array formula

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

    Macro to find column headers wherever we have "x" as value

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

    Finding Column Header Name referencing row values

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

    VBA code to generate Org Chart using Excel data in Visio

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

    Find Top 3 Applications using formula

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

    Multiple dropdowns and Interactive charts

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

    Find Top 3 Applications using formula

    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?
  17. ajoshi76

    Sparklines and Slicers in Excel 2007

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