NVRensburg
New member
- Joined
- Oct 8, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Good Morning 
I have a macro someone helped me with a few years ago and I want to edit it. This macro only indexes the sheet "Pricelist" but i want it to index all sheet in the book. How would i change it? In other words, this macro will search for the keyword in ROW1:1 and return all values with that word in the pricelist sheet. Now I want it to do the same, but with all sheets, not just the PRICELIST sheet?
=IFERROR(INDEX('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5:$A$5000,SMALL(IF('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$H$5:$H$5000="YES",ROW('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5:$A$5000)-ROW('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5)+1,""),ROW(1:1))),"")
I have a macro someone helped me with a few years ago and I want to edit it. This macro only indexes the sheet "Pricelist" but i want it to index all sheet in the book. How would i change it? In other words, this macro will search for the keyword in ROW1:1 and return all values with that word in the pricelist sheet. Now I want it to do the same, but with all sheets, not just the PRICELIST sheet?
=IFERROR(INDEX('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5:$A$5000,SMALL(IF('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$H$5:$H$5000="YES",ROW('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5:$A$5000)-ROW('[Shield Claims NEW.xlsm]INDEXING Pricelist'!$A$5)+1,""),ROW(1:1))),"")