Hi,
Macro will be placed in macro.xlsm & sample1.xlsx & sample2.xlsx , all three files are located at different place so the path should be hardcoded in the macro for both the files so that i can change it as per my needs
Column K of sample1.xlsx should be hardcoded in the macro so that i can change it as per my needs
Column E should be hardcoded in the maro so that i can change it as per my needs
Multiply all the data in column K of sample1.xlsx with sample2.xlsx E2 cells by vba
Thnx Alot
Of all the threads you have started and received replies, you must have learned something that would help you to figure this out.
Show the code you have come up with and explain how it is not working.
Your previous thread I replied to, would have given you an idea on how to do this.
It showed how to loop through a range and add to a value.
Now you need to loop through a range and multiply by another cells value.
Come up with a code yourself. Then ask for help with that code.
I am confused with the loops bcoz we have to loop into both the files
You are only looping in one workbook, multiplying a value from a different workbook.
Sir i dont have that much knowledge about vba macro
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks