Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 01-11-2018, 07:37 AM   #1
Join Date: Jan 2018
Posts: 1
egyblind is on a distinguished road
Question 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.
Attached Files
File Type: xls form1.xls (23.0 KB, 2 views)
File Type: xls master.xls (13.5 KB, 2 views)
egyblind is offline   Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Move Data from Master List to Sheets with City Name meggenm Excel 3 01-28-2016 10:18 AM
Complex calculation from multiple sheets to master sheet inreality01 Excel 49 01-06-2016 03:09 PM
Excel, transfer data from Master Sheet to sub sheets, using key word from column anvqui Excel Programming 9 06-16-2015 01:35 PM
coppy pragraph to another document romanticbiro Word VBA 1 12-01-2014 02:40 PM
How to syncronize data in two different sheets diegogeid Excel 2 09-30-2010 12:19 AM

All times are GMT -7. The time now is 11:31 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft