• 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.

calculating and Copy and paste the data

my files are in desktop
my two files are opened
wolfiestyle.xlsb(vba code will be placed in this file)
1.xls(1.xls file contain 1 sheet, sheet name can be anything)
now what i want vba to do copy all the data of column I of 1.xls except I1 bcoz it is a header and paste the data to amount.xlsx file located in desktop in column B from B1
In amount.xlsx file there is a data in cell A1 multiply that by 60 and paste the result in A2 cell
now count how much data column B has and divide it by A2 example if column B has two data b1 with 100 and b2 with 200 then divide 2 with B2 and paste the result to A3
now divide A3 data with all data in column B and paste the result to column C
now paste column C data to column H of BasketOrder.csv and save and close the BasketOrder.csv and 1.xls file(dont close any other file with it)
I have to do all this by vba so plz have a look
 
Back
Top