I have a sheet named "INDEX" in my workbook which was created with a VBA macro for tabs 1 - 100. They are sequentially names L1 - L100. The index tab has columns where the "NAME" (taken from cell I2 in each sheet) is in column A and the cells with the index links (created with the macro while all sheets were blank) are in column B. The 'name' column automatically grabs its data from a "LAST NAME" cell in the same location in each worksheet. The formula used was " =INDIRECT("L"&(ROW()-1)+25*(COLUMN()-1)/3&"!I2") " On the index page, I have the links separated into 4 columns of 25 links each.
The idea was that when ready to enter a new client, one could go to the INDEX tab and just select the next link with an empty name cell next to it. Once all the data is entered, then the last name in " I2 " of that sheet will show up next to the index link you just selected - and that works perfectly.
I thought I would be able to sort these cells alphabetically to account for adding new clients....but it just doesn't work any way I've tried it. Can anyone point me in a direction to create an index for 100 tabs wherein I can re-sort by names alphabetically as new clients are added ?????
Thanks in advance for your help !!!!
Bookmarks