How to link inside a specific jquery tab?

How do you link part of a sheet tab to an excel cell?

• I have a file that has a few different worksheets. Each sheet tab is the same every month except that I need to add the month to it. For example, every month one tab is "Cash- February", another will be "Credit- February", etc. Is there any way I can keep the one part of the tab that says cash or credit the same and link the month to a sheet tab in excel, so that once I change the month name on my worksheet all the tabs change? Please let me know if you have any suggestions, I have a number of tabs and it becomes very tedious. Thank you!

• Answer:

  You can create a User Defined Formula to do this quite easily - it's not as scary as it sounds... Press Alt F11 to open the Visual Basic Editor. Go to the Insert Menu and select module In the main window copy and paste this code (the next 4 lines) Function getTabName(r As Range) 'this function gives the worksheet name of the specified cell getTabName = r.Worksheet.Name End Function Once you've done this go to Click the file menu and Close and Return to Excel Now back on your worksheet you can just use the formula =getTabName(A1) and it will give you the sheet name. - you could equally point a cell to another sheet if that was useful - e.g. in sheet1 cell a2 I could have =getTabName(Sheet2!A1) which would simply read Sheet2 Hope this helps.