coppy data from sheets to master one
hello dears
please, help me to do this task, as i failed to make it allone, and i usually do it manually.
i've foldar for y17 contains 12 foldar named by month, each one contains from 20 to 25 workbooks day by day ... i want to coppy data from each workbook into mastersheet
note: every workbook contains only one sheet.
i usually use office 2003 on my pc and office 2016 on laptop, so hope code run on both.
attached a sample file for day-wb and master sheet.
thanks for your help.
|