meakashgfx
New Member
- Joined
- Dec 9, 2014
- Messages
- 33
Hi,
I'm having a problem here. In a folder I have 100 employees excel file and a Master Attendance Excel.
I want 100 employees data in Master File.
I need the following VBA:
1. Open employees file copy a Range then close.
2. Paste the data in to master sheet where employee name match.(employee name can be found in "A1" or file name)
3. loop 1 and 2
Please see this screenshot for clear the concept: Screenshot by Lightshot
It will be helpful for me.
Thanks in Advance!
I'm having a problem here. In a folder I have 100 employees excel file and a Master Attendance Excel.
I want 100 employees data in Master File.
I need the following VBA:
1. Open employees file copy a Range then close.
2. Paste the data in to master sheet where employee name match.(employee name can be found in "A1" or file name)
3. loop 1 and 2
Please see this screenshot for clear the concept: Screenshot by Lightshot
It will be helpful for me.
Thanks in Advance!