Move worksheets in a folder to new workbook macro needed

R

rusted314

Board Regular
Joined
Jan 12, 2010
Messages
74
Hi,
Everyday I get 70 emails with excel files for our different locations sent to me. The Excel files have 7 worksheets labeled Monday to Sunday. Each day I need to move all 70 files for the previous day in to a master document. Example today I will place all 70 files in one folder labeled DS and I will need to move all of the "Thursday" Worksheets into a master document. The macro that I have only pastes values but I need the full worksheet moved with all formulas. Please help.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
You must log in or register to reply here.

Similar threads

L
  • Question Question
Moving and renaming multiple workbooks from a master workbook.
Replies
1
Views
266
Luke1690
L
H
  • Question Question
I need an excel macro to open a word .docm and run a macro
Replies
0
Views
83
Hansulet
H
R
  • Solved
Macro To Move Files - Will Not Move .msg or .csv files
Replies
4
Views
105
rachel06
R
D
  • Solved
VB search folder for older version of a file and move it to archive
Replies
7
Views
241
Davefromleeds
D
C
  • Solved
Help matching images in a folder to a worksheet
Replies
9
Views
215
Cruiser69
C

Forum statistics

Threads
1,224,570
Messages
6,179,608
Members
452,930
Latest member
racefanjtd

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top