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

Recent content by Shoebird

  1. S

    Native .xlsx to .shp

    Hello Ninjas Just wondering if there is a native way to convert an .xlsx to a ESRI .shp file. I have come across some python scripts on how to do this but trying to avoid the middlemen. Thanks! Sean
  2. S

    Using Slicer to change a range of cells values

    I have a solution. I used PowerQuery to perform an extract and used VBA on a button to do a refresh all. Thank you to all that viewed this post.
  3. S

    Using Slicer to change a range of cells values

    Hello Ninjas. I have a challenge where I would like to use a slicer to select a name from a range of names contained in a slicer. Based upon the name that is selected, I would like to have range of cells (D6:G20) return the status of modules assigned to that manager. No for the challenge. Is...
  4. S

    VBA to create a dynamic link from a dynamic range

    Brilliant suggestion PCosta. I have done a Power Query request for files and I can only get to the file names but I can't extract the tables imbedded in the files (.xltx, .xlsx, .xlsm). That is why I was thinking that if I could do a concatenation of the file paths and name of the files, the...
  5. S

    VBA to create a dynamic link from a dynamic range

    Hello PCosta. I do see what you mean with "%201". That was a error in the construction of the example and should have been "[Sheet1.xlsx}Table'!$B$1" with the sheet numbers counting up. I did open your attachment and unfortunately, I see...
  6. S

    VBA to create a dynamic link from a dynamic range

    Good afternoon Ninja's. My VBA is not the best and I have been searching the internet for an example that I can make work but I haven't had any luck. What I am trying to do is link two columns that will be of variable length together. Once combined, this will be the path to a specific file and...
  7. S

    Construct a link to another workbook with Concatenate?

    One other thing to note. The source file starts with 'http://sharepoint/... Not sure if this makes a difference.
  8. S

    Construct a link to another workbook with Concatenate?

    Hui, you are awesome! For some reason though, Indirect is not working for me. I did a direct copy/paste from the source document into the workbook I am working on and closed the source workbook to be able to verify the correct address. Constructed Indirect/Concatenate so they are identical and...
  9. S

    Construct a link to another workbook with Concatenate?

    I am trying to construct a dynamic link based upon the concatenation of variables contained in other cells. A1="AHU RTU4.xlsx" A2="//sharepoint/support/Arizona/2016" The concatenation would look like the following: =concatenate(a2,"[",a1,"]Table'!$B$2") This is where it becomes tricky. How do...
  10. S

    Merging Tables from a SharePoint site using Power Query

    Hello all and thank you in advance. I am trying to use Power Query to extract information from a folder in a SharePoint site. I have multiple tables in the folder and I know how to merge tables from a local folder but I am receiving an error when I try to do the same thing from SharePoint. I...
  11. S

    Auto populate a cell in another worksheet.

    Good afternoon all. Here is my scenario and any help would be appreciated. Lets say that in Worksheet 1, a condition is meet with a cell calculated value, is there any way have a text string in a cell in Worksheet 2 auto populated? Ex. Formula for cell B2...
  12. S

    Auto-incorporation of a calculation from a chart

    Awesome! Thank you KenU
  13. S

    Auto-incorporation of a calculation from a chart

    Hello Ninja and thank you in advance for any assistance you may be able to provide in advance. I was wondering if there was a way to link the displayed equation of a line in a chart to a cell. Currently the value in the chart is: y=-1E-09x6+0.0003x5-33.945x4+2E+0610x2+1E+15x-7E+18 The...
  14. S

    How to recreate the equation of the line from an Excel graph.

    Good morning Ninjas. I am running into a situation where I would like to use the information provided by an excel graph with I ask that the equation of the line in exponential format be shown on the graph. The equation provided is y=0.9019e^0.0002x So, how do I use the data that goes into...
Top