I am trying to do a thing automatically. It's part of a more global automatization.
I have a range with the values 0 0 0 0 1 2 3 0 0 0 and I want, on the right, to get the list of 1 2 3 appearing.
Please look at the picture for an example of what I would need to do. Do you have any...
I have the following code which searches for xls-files in a given path and lists me filename, path, sheet names and the content of cells a1 and a2 (titel) in an excel table.
What I need is, that the path appears as hyperlink opening directly the file it refers to. How could I...