VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position
Create Excel Spreed Sheet file which no need press Ctrl+S or F12 for Save after edit . follow the Step 1. Creating Your First Spreadsheet 2. Save your file with macro-enabled .XLSM extension. 3. Press Alt+F11 4. Then Right click on ThisWorkbook and open view code 5.Then copy the code and paste or type same code on white Screen then save and exit Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub 6.Now you can use your favorite Excel file which auto Save withour Ctrl+S.
nice
ReplyDelete