Hi,

There is a folder named "STAR1" in C:\VALUES\ABSTRACTS\VALUES\STAR1

There is a file named "TOTALS.XLSM" in (C:\VALUES\ABSTRACTS\VALUES\STAR1\TOTALS.XLSM)


At "sheet1" of "TOTALS.XLSM" there is a value "1" at cell "K2"



Now, i am looking for a solution to make about 100 copies of "STAR1" and rename each of the copies starting from

"STAR2" in (C:\VALUES\ABSTRACTS\VALUES\STAR2), "STAR3" in (C:\VALUES\ABSTRACTS\VALUES\STAR3) until "STAR100".

And also increase the values at cell "K2" in "TOTALS.XLSM" by 1. so that for folder "STAR2" the value of cell "K2" would be 2 and for "STAR3" it would be 3 etc.

Thanks