Create Index in Excel Sheet

How to Create Index in Excel sheet by using VBA Code


  • Open a New Excel sheet
  • Click on Main tab ( Click on blank area)
  • Click on Customize ribbon.


  • After opening customize ribbon.
  • Click on Add-ins tab
  • Click on Manage [Excel Add-in)  Go Tab



  • Browse File ( Create Index file)
  • Click on ok button.

  • Click on File and click on option 
  • Click on Customize ribbon
  • Click on Macro
  • Click on Main Tab
  • Select Home Tab
  • Click on New Group
  • Do Rename of New Group
  • Select VBA Code ( Ex. Create Index.Xlam..)
  • Select created New Group
  • Click on Add button
  • Click on New Tab
  • Do rename of New Tab
  • Select any Icon
  • Click on OK


  • After completion of above process, a new icon will be created under home tab
  • Click on new icon ( Create Index)
  • Index sheet will be created.



Thank you






Comments

Post a Comment

Popular posts from this blog

Skill Matrix Tool & Excel Format

Image
Skill Matrix Tool About Skill Matrix: A skill matrix tool , also known as a competency matrix or skill assessment matrix, is a valuable resource for organizations and individuals alike. It helps assess and visualize the skill levels and proficiencies of individuals within a team or organization. Here are some benefits of using a skill matrix tool: Identifying Skill Gaps: A skill matrix tool allows you to clearly see where there are gaps in skills within your team or organization. This can help in planning training and development programs to address these gaps and enhance the overall skill set. Training and Development Planning: With a skill matrix in place, you can create targeted training and development plans for individuals. This ensures that employees receive training that is directly relevant to their current skill levels and future career goals. Succession Planning: Skill matrices can assist in identifying potential successors for critical roles within the organization. By un
Read more

How to take print out of multiple pdf files in one click.

Image
  How to take print out of multiple pdf files in one click. Step-1 Save all Pdf files in a folder. Step-2 Open control panel and select "printer and devices". Right click on printers and devices Click on the option  "See What's Printing" A new window will open, keep it open and do it smaller size.  Step-3: Open "What's see printing" window & file folder in parallelly. Select all files in folder.  Step-4 Drag all selected files from folder to " See what's printing" window. Step-5 Click on Yes, all prints will come in one command. Thank you
Read more

Use Vlookup in multiple columns at a time

Image
माइक्रोसॉफ्ट एक्सेल में  30 कॉलम में एक साथ VLOOKUP FORMULA कैसे लगायें।  वीडियो को देखने के लिए यहां क्लिक करें। How to vlookup multiple columns in Excel – example Here is the VLOOKUP formula we have: = VLOOKUP ( I2,A:F, { 4 , 5 , 3 } , FALSE ) But you can’t just insert this formula into J2 cell and hit enter. This would only return one value. What you need to do is select a vertical array that corresponds to the number of columns in your VLOOKUP formula. In our case, we need to select three cells. After that, you can insert the formula to the formula bar and press  Ctrl+Shift+Enter  for Windows ( Command+Return  for Mac) – this will apply an array formula in Excel. Excel Online vlookup to return multiple columns  In Excel Online, VLOOKUP works almost the same way, but you don’t have to select an array and press the combination of buttons to implement it. You can just insert the formula in one cell and press  Enter  => the matching values for the columns specified in the formula w
Read more