LearningVBA
New Member
- Joined
- Sep 16, 2006
- Messages
- 14
I have approximatly 300 workbooks sent to me each month, all of which are saved to a holding folder (one folder for each month of the year). Is there an automatic way in which the files can be opened up in turn and the cells B33:AZ 5033 can be copied and pasted back directly as values before closing and saving the workbook. The worksheet is called "Summary".
I've had a look at old posts but cannot see what I'm after.
I've had a look at old posts but cannot see what I'm after.