Tag: date function

LOOKUP & Reference Leave a comment

Index Function In Excel-2

Index     With the help of INDEX function in excel we get value from a table or range on the intersection of a row and column position within the table or range. The first row in the table is row 1 and the first column in the table is column 1.   एक्सेल मं हम Index फंक्शन की मदद से table या range से हम row और columne के कटाव का value प्राप्त करते हैं. पहला row table में […]

Read more
VBA/Macro Leave a comment

Copy All Sheets Data In Master_Sheet

Copy All Sheet Data In Master_Sheet   I have excel file which has 3 sheet,From below vba macro code we can copy all sheets data in master Sheet.   मेरे पास तीन sheet वाली excel फाइल है.निचे लिखे VBA Macro Code से हम सारे  sheets का डाटा Master Sheet में copy कर सकते हैं. Sub Add_All_sheet_Data() sheetcount = Sheets.Count Worksheets.Add after:=Sheets(Sheets.Count) ‘Worksheets.Add after:=Sheets(Sheetcount) ActiveSheet.Name = “Master” For i = 1 To sheetcount Sheets(i).Activate Range(“a1”).CurrentRegion.Select Selection.Copy Sheets(“Master”).Activate Range(“a1048576”).End(xlUp).Offset(1, 0).Select ActiveSheet.Paste If […]

Read more
Some Other Excel Tips 3 comments

Extract First Name From A Cell In Excel

                    I have to extract first name from a cell in excel. हमें एक्सेल में एक cell से first नाम निकलना है.     Here we have only one logic that from start to end, what is the position of first space in cell, we have deduct 1 in that position, then from left side we will pick number character with help of left function to extract first name.   यहाँ हमें […]

Read more