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
sample files are attached below plz have a look sir




Reply With Quote

Bookmarks