Search results

Dear Nilay Why you are prefering for VBA code to do this. Excel built in functions can do this for you without using the VBA code. Please enter the below formula in sheet "PL" cell B12 and drag it down. =IFERROR(VLOOKUP(A12,Data!$A$3:$B$31,2,FALSE),"") Please inform if anything goes wrong.

Dear Kacyi In your above question, you mentioned "I need to find a way to copy comments I made on the old file", here comments means cell comments ( as yellow color box at the corner of the cell) or just you typed some text in that cell. Please clear to resolve the problem

Dear Santhosh from which column (B,C,D,E), you want to insert one column before(left side) and one column after (right side). I can't able to findout. Please suggest.

Dear Abhijeet, VBA code to work properly, you must first create reference to the Filesystemobject. Tools -> References -> Microsoft Scripting Runtime

Dear Abhijeet I hope the below code will work. Sub FileDetails() Dim fso As New FileSystemObject Dim myFolder As Folder Dim myFile As File Dim i As Integer Set myFolder = fso.GetFolder("D:\ARRAY FORMULAS") ' change the folder path If myFolder.Files.Count > 0 Then i = 1...

Dear Santosh I can't able to understand your problem and requirement. Could you please elaborate more? Sorry... :(

Dear rumshar Please have a look at this link. It might be helpful http://www.vbaexpress.com/kb/getarticle.php?kb_id=379 http://datapigtechnologies.com/blog/index.php/forcing-your-clients-to-enable-macros/

Failure will teach more than the success

Dear rumshar If you are familar with VBA, you can put VBA code at the event of file opening. My idea is, you should force all the users to enable macros before watching the report (not verbally or personally, just use the power of VBA). Your code should force them to enable the macros and you...

Congrats NarayanK991 Sir. :):):) I hope you can always teach and share your knowledge with us.

Dear Santosh Please open your desired excel, in which you wants to put this macro. Press Alt+F11 to open VBE editor. Then left side there will project explorer. You can see Thisworkbook object. Double click on it to open the editor. Then a blank window will appear. You paste the above code...

Dear Ashish Please find attachment. I hope it will resolved your problem. Just click Macro button to fill data.

Dear Krispar Can you elaborate more. What does it mean "combine". If you want to merge all the sheets into one sheet with the same standard structure, please upload sample file with explanation

I think that... it is pivot table

Dear Aurelie Thank you so much for your suggestion. I already go through this websites. I preferred Techonthenet.com. Very good explanation and their using. During this search i found another site http://www.functionx.com. Cleared explantion along with example databases. I liked so much

Dear All, Can you please suggest me the best online training/tutorial provider for Ms Access 2010 including both beginners and advanced level. I have little bit knowledge in Ms Access 2010 through reading online blogs and books and watching online videos at youtube. But I can't able to apply...

Dear Afaraq If you change date formate, then below will work for you =SUMPRODUCT((A2:A377=F2)*(B2:B377=H2),D2:D377)

Failure will teach more than the success

I have created small macro... i hope it will help you. Sub CellFormat() Dim cell As Range Dim rng As Range Set rng = Application.InputBox("Select Range", "Range selection", , , , , , 8) For Each cell In rng cell.NumberFormat = "m/d/yyyy" Next End Sub

Please try the below formula in C4 =VLOOKUP($C$3,compAddress!$B$4:$F$6,ROW()-2,FALSE)

Please have a look http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/

Dear Suril Please read this: http://www.excelhero.com/blog/2010/07/excel-partial-match-database-lookup.html I think it will resolve your problem

Sorry ... how can we use this trick in countif. like if i want to count the number of cells which are the year 1908. How can i do that

thank you so much somendra misra.. It works like charm

Dear thifu3, You can use =COUNTIFS() to get the results. As per your data range, =COUNTIFS(A1:A5,A11,B1:B5,">0"), in this i used A11 as criteria (5 Years).