i have to change M/C name manualy for every M/C for each sheet (158 times). there are 30 sheets. i have solved this by changing "M/C name" to cell #.
Quote:
|
=SUMIFS('[01-02-23-BB.xlsx]DELEV-B'!$O$9:$O$568,'[01-02-23-BB.xlsx]DELEV-B'!$C$9:$C$568,C7)
|
but i have to 1st open data files and work? there are 58-62 files originally in there. how do i work around that?