Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto RenameTabs!!!
Hello, Need help on Tabs within excel spreadsheets. I have a spreadsheet that have multiple tabs. Each tab is labeled with a name of an item I am selling. I also have a Tab I call the master tab which has ALL the names of the items on there. (i.e Grapes, Apples, Oranges, Banana's I am currently selling.) Each tab references the master tab to retrieve the item name and information on there. Each of the tabs look fine but if the order of referencing the cells in the master tab changes, I then need to go into each tab and rename the tab name to the correct item name that is on the particular tab. For example, Sheet2 now has information on Apples as it references a certain cell in the master sheet(Sheet1). So now I want to name that particular sheet(Sheet2) to 'Apples'. The following week the cell 'Apple' in the master sheet changes to 'Banana'. So now I want the 'Apples' tab name to turn to 'Banana'. Is there a way in VB or simpler way to make this happen automatically? I don't want to keep re-typing new names for each and every tab. (I have lots of tabs in this spreadsheet.) I don't know VB at all so if someone can give me a place I can go to find this 'CODE' it would be much appreciated. Please help!!!! PS: I do not want to use MS Access right now. -- Maxwell-5000 ------------------------------------------------------------------------ Maxwell-5000's Profile: http://www.excelforum.com/member.php...o&userid=26056 View this thread: http://www.excelforum.com/showthread...hreadid=522313 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
Auto Excel workbook close: save= false during an auto subroutine | Excel Programming | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |