Hi guys, it's again me today I understood how I can combine all information from different excels into one.
But then in my mind came the other idea about, How I can change some info in different Excels files which store in one folder.
Example: change date and add some info in a lot of different same places in the same excels ( with VBA code )
Note: in the same excels with same places change only excel name as numbering Example: Certificate1 , Certificate2, Certificate3....... the can be nearly 500-600 files in folder.
Location: Example:
R16C25 = date which i have in excel previously 01.01.2021
R83C2 = date + 6month free cell should add date 01.07.2021
R84C2 = date +6 month free cell should add date 01.01.2022
R83C7 = Name free cell should add Name Jack Thompson
R84C7 = Name free cell should add Name Jack Thompson
R83C12 = Text free cell should add Work Done
R84C12 = Text free cell should add Work Done
Sheet name = W Certificate W Certificate
Sheet stay the same without any changes ( just write fore information for VBA formula if it's needed )
But then in my mind came the other idea about, How I can change some info in different Excels files which store in one folder.
Example: change date and add some info in a lot of different same places in the same excels ( with VBA code )
Note: in the same excels with same places change only excel name as numbering Example: Certificate1 , Certificate2, Certificate3....... the can be nearly 500-600 files in folder.
Location: Example:
R16C25 = date which i have in excel previously 01.01.2021
R83C2 = date + 6month free cell should add date 01.07.2021
R84C2 = date +6 month free cell should add date 01.01.2022
R83C7 = Name free cell should add Name Jack Thompson
R84C7 = Name free cell should add Name Jack Thompson
R83C12 = Text free cell should add Work Done
R84C12 = Text free cell should add Work Done
Sheet name = W Certificate W Certificate
Sheet stay the same without any changes ( just write fore information for VBA formula if it's needed )