Hi,
I am looking for a macro that will first Inform me to put a file to a path & then only it will start the process & if i don't put the file in that path then that macro will not proceed it will keep informing to put that file
Hardcode the path path of the file & name of the file in the macro itself so that i can change it as per my needs
Macro will be placed in a master.xlsm
there are 2 files name 1.csv & 2.xls
we have to Match Column Aof 2.xls with Column A of 1.csv & if it matches then we have to compare column E of 1.csv with column C of 2.xls & if column E of 1.csv is greater than column C of 2.xls Then Buy in column D of 2.xls & if column E of 1.csv is smaller than column C of 2.xls Then put Sell in column D of 2.xls
Thnx for the Help
Bookmarks