happyorange
New Member
- Joined
- Jun 15, 2015
- Messages
- 1
Hi,
OS - Windows 7
Excel Version 2007
I am given 50-60 excel files with data in the same format. I need to perform addition/subtraction on those data and save them in separate excel file. Is it possible to perform this action using macro. Every time I will be given some 40-50 files and I have to add the counts in the all the files in a separate file and share the same with them. Actually I am a data analyst and I am given to write a macro, of which I don't have much knowledge.
I need to get back to manager by end of this week. It would be grateful if I get some help with the codes.
OS - Windows 7
Excel Version 2007
I am given 50-60 excel files with data in the same format. I need to perform addition/subtraction on those data and save them in separate excel file. Is it possible to perform this action using macro. Every time I will be given some 40-50 files and I have to add the counts in the all the files in a separate file and share the same with them. Actually I am a data analyst and I am given to write a macro, of which I don't have much knowledge.
I need to get back to manager by end of this week. It would be grateful if I get some help with the codes.
