L
Legacy 450448
Guest
See the attached files
Vba is placed in a seperate file
Open 1.xls file
Calculate the data add all the data in column H and paste the result in K9 of vba contained file in sheet1
and close the 1.xls file
Download the sample file from the below link bcoz i was unable to upload so plz have a look Sir
https://mega.nz/#!7rZEnCCb!E5lMj6wt08ybge0VyWxmiHaMENjJwDsfuhTELqmvAsY
https://mega.nz/#!fvQQCIha!9fP0-tOleJJKytWKzJfSWTwMt-dJ5HrGYm-fTQh7WSk
Vba is placed in a seperate file
Open 1.xls file
Calculate the data add all the data in column H and paste the result in K9 of vba contained file in sheet1
and close the 1.xls file
Download the sample file from the below link bcoz i was unable to upload so plz have a look Sir
https://mega.nz/#!7rZEnCCb!E5lMj6wt08ybge0VyWxmiHaMENjJwDsfuhTELqmvAsY
https://mega.nz/#!fvQQCIha!9fP0-tOleJJKytWKzJfSWTwMt-dJ5HrGYm-fTQh7WSk