Hi Everyone,
I am new to this forum and in need of an excel macro help.
I have few excel files in a folder. one for each month.
In every excel file, there are columns with same headers. In column A of every file there names of employees.
What I want to do is, once I run a macro a new file for each employee name should be created and saved at the same path.
For example, Once I run macro, Data for all "A" from column A should be appended on below the other. And the file should be saved as File A at the same path.
So end result will have 3 files "File A", "File B" and "File C".
I have attached here files for Jan Feb and Mar for demo purpose.
If anyone of you can help me then that would be great.
Thank you.
Bookmarks