I have 120 files in a folder and need to calculate each column within each file the same. Can someone help me write a macro that will perform the same calculation in each spreadsheet?
The rows on each spreadsheet will differ so if the calculations can be placed on the 3rd row after the last data row, that will work.
SiddharthRout had helped me with this once but the rows in the calculations have changed and I cannot seem to get it to work. Experts-Exchange.xls