Hi all,
I need to create a dynamic file path with VBA, where the correct name of the folder depends on each cell in a range.
e.g.Please Login or Register to view this content.
Cell (B25) = Spring2019
Cell (B26) = Spring2018
Cell (B27) = Spring2019
Cell (B28) = Spring2017
Cell (B29) = Spring2018
Pasted formula in cells:
Cell (C25) = IF(B25="","",INDEX('S:\COMMON-HK2\Cluster Plan - Mens - 2019 - SPWR.xlsb'!Attribute_Material,A25))
Cell (C26) = IF(B26="","",INDEX('S:\COMMON-HK2\Cluster Plan - Mens - 2018 - SPWR.xlsb'!Attribute_Material,A26))
Cell (C27) = IF(B27="","",INDEX('S:\COMMON-HK2\Cluster Plan - Mens - 2019 - SPWR.xlsb'!Attribute_Material,A27))
Cell (C28) = IF(B28="","",INDEX('S:\COMMON-HK2\Cluster Plan - Mens - 2017 - SPWR.xlsb'!Attribute_Material,A28))
Cell (C29) = IF(B29="","",INDEX('S:\COMMON-HK2\Cluster Plan - Mens - 2018 - SPWR.xlsb'!Attribute_Material,A29))
However, below does not seem to work. I was hoping I can combine the R1C1 referencing with a formula to get the last 4 characters from the relative cell in column B.
Please Login or Register to view this content.
Bookmarks