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
Bookmarks