calculation by vba

[kancha123]

Multiply the value of B2 by 1.5%, then multiply that result by 56 and then paste the result in D2(i need only result in the cell no formulas)
note- 1st row contains headers so ignore the first row
The file will be located in C:\Users\sk\Desktop and file name is sample.xlsx
file is not opened so we have to open the file by vba and do the process and save it and close it
vba will be added in a seperate file process.xlsm
both files are located in same place
i need vba to do the same

 

[IRstuff]

So, there's a macro recorder in Excel; once that's recorded, you just need to wrap a FOR loop around it and put in variables.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[kancha123]

I tried but i was unable to edit the same so i deleted the same sir
Plz have a look Sir

 

[SkipVought]

I tried but i was unable to edit the same so i deleted the same sir

Then you must 1) record your steps again and 2) upload your workbook with your recorded macro.

This is imperative!

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[davidbeach]

Student posting is prohibited.