Hi,
Macro will be placed in macro.xlsm, macro.xlsm & basketorder.xlsx both are located at diiferent path so the path of basketorder.xlsx should be hardcoded in the macro so that i can change it as per my needs
If J is Buy then add .05 to to column L & put the total to Column G
If column J is Sell then subtract .05 to to column L & put the total to Column G
Thnx
Bookmarks