• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy and paste of the data between files and divide it

Status
Not open for further replies.
I have two files opened
1.xls
sample.xlsb
now what i want is copy all the data of coulmn I except I1 of 1.xls bcoz it is a header and paste the data to column D of sample9.xlsx and divide all the data of column D with B3 and paste the result to column E
vba code will be placed in sample.xlsb
and one more thing B3 has formulas and we have to divide the result of the formula with Column D data
 
Status
Not open for further replies.
Back
Top