Go to Linked cell In Excel Formula

In excel when we make formula with another cell, then we require to go that cell. एक्सेल में जब हम किसी और cell से formula बनाते हैं तो हमें उस cell में जाना पड़ता है.   Then we use name box or Goto special methods. उस cell में जाने के लिए हमें Name Box या goto special method का उपयोग करतें हैं.   With Name box:- We type computer in R100 Cell and in cell F4 typed =R100 then value from […]

Read more

Open Last Modified Excel File From A Folder Through Vba

Dear All,   We can use below vba code to open last modified excel file from a folder.   Sub Last_Modified_File() x = InputBox(“put Folder Path”) folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) If dttime > qq Then qq = dttime End If flname = Dir() Loop folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) […]

Read more

Match With Index In Excel

Use of Match Function With Index Match Function के साथ Index फंक्शन का प्रयोग     The INDEX MATCH formula is the combination of two functions in Excel: INDEX and MATCH.   INDEX MATCH formula Excel में Index और Match दो Functions का संयोजन है।   =INDEX() returns the value of a cell in a table based on the column and row number. Column और Row की संख्या के आधार पर तालिका में cell का Value लौटाता है। =MATCH() returns the […]

Read more