That works pretty nice. I have a question? For example we have 12 sheets in work book, each sheet has 3 set of 10 rows that contain names. How would you create a formula that will change the name or add the name in forward set of rows/sheets in same cell. What do I mean by that? Lets say in work sheet 3 second set of rows I add the name or change the name formula will change or add the name in same sheet in third set of rows and the remaining of worksheets 4,5,6,7,8,etc how ever it does not change it backwards in previous work sheets or set of rows. Hope it makes sense.
