H
halem2
Hi:
I have a workbook with about 250 worksheets, let's call it MW.xls. All
worksheets have a name(a1, a2, etc). Once a week I copy groups of
worksheets and save them as different workbooks(let's say wb1.xls,
wb2.xls). Those workbooks get updated and emailed back to me. I receive
about 15 workbooks through email.
I need to copy different cell ranges from the updates workbooks'
worksheets (let's say from wb1.xls) to the original one(MW.xls). So if
in the emailed workbook I have worksheets a1, a2, a3, I need to copy
cell ranges b5:k5 and a7: j10 to the same worksheets in the original
workbook(MW.xls).
It is a very tedious process and it is identical for every sheet.
Thank you in advance for any help,
I have a workbook with about 250 worksheets, let's call it MW.xls. All
worksheets have a name(a1, a2, etc). Once a week I copy groups of
worksheets and save them as different workbooks(let's say wb1.xls,
wb2.xls). Those workbooks get updated and emailed back to me. I receive
about 15 workbooks through email.
I need to copy different cell ranges from the updates workbooks'
worksheets (let's say from wb1.xls) to the original one(MW.xls). So if
in the emailed workbook I have worksheets a1, a2, a3, I need to copy
cell ranges b5:k5 and a7: j10 to the same worksheets in the original
workbook(MW.xls).
It is a very tedious process and it is identical for every sheet.
Thank you in advance for any help,