Search results

Sajan; Good idea! I will try that but returning 1 for anything greater or equal to 1 might be a problem. Narayank; Its good to hear from you again! Your answers are always awesome! Good article and nice suggestion.

Hello everyone, My pivot table returns zeros in -1.86517468137026E-14, 1.46549439250521E-13, -2.28261853862932E-13 format and I need my formulas to read this as zeros. I changed the output numbers to accounting, numeric but it didn't work. Example; Pivot output A1: -1.86517468137026E-14 A2...

Shrivallabha, This code is excellent. Thank you and everyone in this thread so much for your help! You guys are awesome!

Shrivallabha, I love the recent code!!! Your code worked great but I have one more thing to ask; excel list doesn't update when I delete one of the files in the folder It only updates when a new file is added. Do I need to make this a loop?

shrivallabha: First one (ListAndHyperlink) worked great and it is exactly what i needed. Actually, is it possible to hyperlink the file names instead of heaving a separate list that says click here? Thanks a million! Krishnakumar: Thank you so much for the link. It is great to be able to...

All, I am kind of new to vba and I got lost during your discussion. Would anyone explain whats going on little more simply? Thanks!

I found this online and it looks like it would work but how do I hyperlink them? Also, thanks for those links SirJB7 Sub ListAllFiles() Dim fs As FileSearch, ws As Worksheet, i As Long Set fs = Application.FileSearch With fs .SearchSubFolders = False ' set to true if you...

I had no luck! Do you have the link by any chance?

Hi all, I need a macro to look into a folder (i.e. C:\Documents) and list all the files (*.pdf) in a spreadsheet and hyperlink them. Thank you very much!

This works great! You got it to work exactly how I wanted it. Thank you very much Narayan. You are really good at this! I really hope you will be interested in my future questions/posts :) I greatly appreciate your help!

I see! That changes everything, I can't believe I missed constants part. However, I still can't get "ClearContents" part work separately. Whenever I run the macro, it clears the first row when there are several more rows.

Narayan, Your code looks like it would work but for some reason it only clears the firs row without deleting any other rows. When I read your code, looks like it got everything and there is no reason why it wouldn't work. I think I need to spend some time on modifying your code. Thank you so...

Hi, Yeah, whenever its convenient for you. I really appreciate your help! Thank you!

Narayank, I really appreciate your help and interest. This is a very silly (but annoying) problem and I will try to explain all the requirements. The whole idea was making a form without using Infopath. I wanted copy InfoPath's Repeating table option to excel. Row 6 will always be there to...

Narayan, I have been trying this code and I am still having difficulty with clearing row 6. The code you posted clears row6 at the same time with row 7. I mean, when you try to delete row 7, it automatically clears row 6 too. I think I need a private macro where this macro (above) will run...

Narayank991, Thank you so much for the code. I changed it little bit and works great for my table. Only thing that is missing is that I still can't get it to ClearContents for row 6. Here is the code if anyone needs it. Public Sub DeleteLastRow() 'This one works and its table specific...

Hi Narayank991, Thank you for your interest in my question and you are right; I should've been more specific. This is going to be the user form and it will include the header and row 6 then, if the user feels the need to add rows, they will be able to do it using this macro. 1. I want it...

Hi everyone, I am looking for a macro that will find and delete the last (blank) row in a table (It can look for a value in any table cell). It gets tricky because I have two tables in one sheet and I need two individual macros for each table. I don't want macro to find any blank row...

mercato: Thank you for your simplification. It is exactly what I need it (my level:). Narayank: Thank you so much for the follow up. No wonder why your "Excel Ninja". You guys are awesome!

That sounds great, Narayank991. Thanks again!

YES!! Thank you so much Narayank991, I have been looking for this, forever. I will try to figure it out but your worksheet is little bit complicated for me. If you feel like you can explain more in the future, please do! Thank a lot!

Hi bobhc, Thank you so much for the video but it did not cover what I was looking for. My problem is little bit more specific and most videos just cover basic drop down instructions. Thanks again.

I want to say that this is a great website! I've learned a lot from this site but I have been trying to create depended data validation and couldn't find an answer to my problem. I can create drop down list for people to choose a time to sign-in, however, I can not get sign-out data...