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...
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...
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...
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...
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...
I am trying to construct a dynamic link based upon the concatenation of variables contained in other cells.
The concatenation would look like the following:
This is where it becomes tricky. How do...
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.
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?
Formula for cell B2...
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:
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...