hi guys,
i have an issue where the following index letter $E7$:$E$100000 changes whenever i enter a call to refrence sheet "Raw Data for PR Dist"
Code:
=IF(INDEX('Raw Data for PR Dist'!$E$7:$E$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR Dist'!$B$7:$B$100000),0))="","",INDEX('Raw Data for PR Dist'!$E$7:$E$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR Dist'!$B$7:$B$100000),0)))
such as when i run the vba the first time it will insert a column in the refrence sheet.
every time i run the Macro the same thing happen, thus $E7$:$E$100000 becomes $F7$:$F$100000 then $G7$:$G$100000...etc
how can i lock $E7$:$E$100000 to NOT change whenever i run the Macro ?
i saw something about indirect but am not sure if it will work or if there is a better solution.
THank you
Bookmarks