Copying the name of the folder in the query setting was was a GOOD IDEA!!!.
@ChesterTugwell
Жыл бұрын
Sometimes I have them (not that often though)
@NarkissosK
4 күн бұрын
Hello, there. Excellent video for a start. I have a question. I have a customer that has huge file names on hos files. The problem is i can t copy them to another folder. So my solution is to rename all his folders (1,2,3,4 etc) and then map them with the appropriate name in an excel file, to shorten the file path. My question is how do i map the subfolders in the same excel and keep the folder structure inside the excel so as not to confuse the customer and has the same folder structure? Thanks in advance
@digambarbhide7867
10 ай бұрын
Extremally useful video! Great job Chester. Thanks a lot. All your videos are very informative and are in simple step by step procedure. I think if the excel file is saved in the main folder then the links will work even if the entire folder is copied to other location. Any comment!
@MouradMAGMA
Жыл бұрын
Hello, Thank you for the tuturial. Does it also work with Google Sheets?
@aahalol
Жыл бұрын
Amazing! Much appreciated!
@vidyadharvm4132
Жыл бұрын
Thanks very helpful
@naveedyousaf1657
Жыл бұрын
Very Useful. Thanks for sharing.
@ChesterTugwell
Жыл бұрын
Glad it was helpful!
@teoxengineer
Жыл бұрын
Thank you so much for this useful tutorial. How can we use Hyperlink function by dynamic cell reference?
@bovallandingham
Жыл бұрын
is there a way to do this, send the doc via email or drop the files off in something like DropBox so when downloaded by the recipient, the hyperlink still works?
@lannyverse
2 ай бұрын
Would it still be visible if i share the excel to client through email?
@mustavogaia2655
Жыл бұрын
Hi, Mr. Tugwell, is there a video about automatically opening a hiperlink inside a excel spreadsheet. My job requires that I download a good number of pdf filas by clicking on the hiperlink available in the spreasheet. So my routine is to click on the hiperlink ans save the files in a given folder (I only need to open tham later.) Maybe this is too much into VBA, or an ordinary app would do the trick, but I would appreciate if you go do a video showing how to do this. Thanks. Nice video btw.
@ChesterTugwell
Жыл бұрын
Mustavo, where are you downloading the pdf files from?
@mustavogaia2655
Жыл бұрын
@@ChesterTugwell From a server/web application from the Court where I work.
@ChesterTugwell
Жыл бұрын
OK, can't promise anything but I'll keep this in mind for a video topic.
@mustavogaia2655
Жыл бұрын
@@ChesterTugwell Thanks. No worries. If you show how to make a macro that "clicks" the hiperlink its more than enough. I think other people would like it also.
@vinothsekar5472
Жыл бұрын
Hi Tugwell, I have a data with a different ID and the adjacent column contains numerical value with respect to each ID. I receive every day these data and sometime, some of the ID will not contains numerical value in the adjacent cell. I need to find the difference of a particular ID i.e., today's data with previous data. If the previous data is blank then it has to check the next previous data which contains the numerical value. I dont know how to figure out the formula for this case.
@GokhanOrmeci
6 ай бұрын
How could we do this on 365 Excel and a Sharepoint folder?
@أبوسلام-ذ5ر
4 ай бұрын
Thanks a lot
@mechanoid5739
9 ай бұрын
Can you tell me how to copy a page containing multiple hyperlinks to a new workbook without the hyperlinks being stripped off the new page in the second workbook. I have this problem and it is driving me crazy!
@liberatingtruthseeking5513
11 ай бұрын
can u call a excel or word bookmark from a folder ?
@cyrusicemansoberano5019
Жыл бұрын
=COUNTIFS(H17:I17,"X",F17,"Active") why it shows #value? and if this =COUNTIFS(H17, "X",F17,"Active") it works, what seems to be the problem with this Sir, I need to count the X in multiple columns, thank you in advance
Пікірлер: 25