Hi
I have over 900++ individual excel files that contain data from different inverters. The layout of each file is identical and there is a particular column in each file containing different cells that require summing and writing the result of sum on a new cell in each file.
the file location in c:\ test file.
file end is .csv
the cells that have the data that I want to sum :
L15 TO L26 =
L27 TO L38=
L39 TO L50=
L51 TO L62=
L63 TO L74=
L75 TO L86=
L87 TO L98=
L99 TO L110=
L111 TO L122=
L123 TO L134=
L135 TO L146=
L147 TO L152=
I want to see the data in any type of formatting (csv.xls.xlsm)
Any help is appreciated
THANKS IN ADVANCE
I have over 900++ individual excel files that contain data from different inverters. The layout of each file is identical and there is a particular column in each file containing different cells that require summing and writing the result of sum on a new cell in each file.
the file location in c:\ test file.
file end is .csv
the cells that have the data that I want to sum :
L15 TO L26 =
L27 TO L38=
L39 TO L50=
L51 TO L62=
L63 TO L74=
L75 TO L86=
L87 TO L98=
L99 TO L110=
L111 TO L122=
L123 TO L134=
L135 TO L146=
L147 TO L152=
I want to see the data in any type of formatting (csv.xls.xlsm)
Any help is appreciated
THANKS IN ADVANCE