Leonardo1234
Member
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
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