Hi,

Did anyone know how to add logic in VBA to save the file depending on a certain value on the sheet?

For example I have static path in settings tab, cell B2: savePathOrderack = Worksheets("settings").Range("B2").Text

But in the MAP tab I have:

A B C
1 90 ARN C:\\test\90
2 80 ARN C:\\test\80

on the actual ORDER tab I would have:
A B C
1 ORDERID ORDERDATE SUPPLIERID
2 918800188 20210810 90

So I would need that l based on C2 from tab ORDER, savePathOrderack to read from MAP tab C1. It's based on SUPPLIERID that is on ORDER sheet and on MAP sheet