Hello - - I was hoping for some assistance with my task. I have a folder (W:\employee data\YE\DirAndAbove\) that contains about 100 workbooks. One worksheet each. All of the worksheets are the same, formatting and formulas. The only difference between the the workbooks would be the amount of rows of data, some would have 5 rows (starting in row 10), some may have 50. The first 10 rows have calcs and summary info based on the detail data What I'd like to do is have VBA code:
Open each workbook (one at a time)
Copy the one sheet to another sheet, name this new sheet 'sandbox'
Protect the original sheet - allowing for edits to cells H10 to H50 and L10 to L50.
Close this workbook and open the next, repeat..
All forumulas and formats should be copied as well.
Can someone out there in excel-guru land help me with a some vba examples? Thanks for reading! I'm attaching an example of a workbook that I'm referring too, it was modified so some of the formulas are gone, etc.
Bookmarks