I have a sheet named "Tracker" with about 80 items and columns that go from A to AA. My intention is to create a template that will populate basic information from the tracker sheet. Each item is numbered in the A column and I plan to add 80 additional sheets all named "1", "2", "3" etc... Once I have the first sheet working.
So, I have =MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,5) in cell A1 on my sheet named "1". Then I added =INDEX(Tracker!W3:W82,MATCH(A2,Tracker!A3:A82,0)) to pull in the name from the W column. I get #N/A result. If I type "1" instead of using the filename formula it gives a good result.
I am trying to avoid typing on each sheet, is there a way to automate this so when I add a sheet and name it "2" it will pull in the information for the next item?
So, I have =MID(CELL("filename",A2),FIND("]",CELL("filename",A2))+1,5) in cell A1 on my sheet named "1". Then I added =INDEX(Tracker!W3:W82,MATCH(A2,Tracker!A3:A82,0)) to pull in the name from the W column. I get #N/A result. If I type "1" instead of using the filename formula it gives a good result.
I am trying to avoid typing on each sheet, is there a way to automate this so when I add a sheet and name it "2" it will pull in the information for the next item?