no mathematician wrote:
Excelhelp wrote:Needs to be seamless, 100 tabs possibly or more, all automated.
I'm no math wiz, but from my calculations, you need 51 tabs (one master and one for each of the 50 cards). What are the other 49+ tabs for?
For future additions, or adding in other offices cards.
This is what worked, and to create a new tab just copying the formula over and naming the tab the last 4 digits and it works seamlessly. No manual work by anyone. It only took that person about 90 seconds to write.
=IFERROR(OFFSET('1'!A$1,LARGE(ROW('1'!$B$1:$B$10000)*IF((REPLACE(CELL("filename",$A$1),1,FIND("]",CELL("filename",$A$1)),""))=RIGHT('1'!$B$1:$B$10000,4),1,0),ROW()-ROW($A$1))-1,0),"")