I am trying to explain here my best,
There are 10 people are filling one data sheet individually, At end of the day they are placing them sheet in one common folder(share folder). After that i have to copy all data from individual sheet and have to paste in one MASTER SHEET.
Is there any way to do some automation can collect data from all sheet and paste(place) in MASTER SHEET.
Thanks a lot in advance..
There are 10 people are filling one data sheet individually, At end of the day they are placing them sheet in one common folder(share folder). After that i have to copy all data from individual sheet and have to paste in one MASTER SHEET.
Is there any way to do some automation can collect data from all sheet and paste(place) in MASTER SHEET.
Thanks a lot in advance..