barim
03-29-2018, 08:09 AM
Hello,
Would it be possible to accomplish this with a macro?
I have a folder of 150 files that I need to sum all highlighted cells per columns.
As you can see from attached workbook each column has various numbers of highlighted cells.
Fortunately, all column headers are same and stretch from A through N.
Number of rows is different and data could end with row 20, 150, 750 etc.
I need a macro that would open each file in the folder and look through these columns and sum these numbers like it is shown in the workbook.
Now, I need cumulative numbers for all files throughout all columns to give me a total of highlighted cells. This could be a new workbook.
I hope I gave you sufficient information. Thanks in advance. 21945
Would it be possible to accomplish this with a macro?
I have a folder of 150 files that I need to sum all highlighted cells per columns.
As you can see from attached workbook each column has various numbers of highlighted cells.
Fortunately, all column headers are same and stretch from A through N.
Number of rows is different and data could end with row 20, 150, 750 etc.
I need a macro that would open each file in the folder and look through these columns and sum these numbers like it is shown in the workbook.
Now, I need cumulative numbers for all files throughout all columns to give me a total of highlighted cells. This could be a new workbook.
I hope I gave you sufficient information. Thanks in advance. 21945