M
mellowe
HI All
Is there any way to compile the contents of all the sheets on a
workbook into one sheet where the range is to be copied is A45:T500 on
each worksheet - and each worksheet is named by date e.g 06-02-06,
07-02-06 etc. The columns and format are the same throughout the
workbook, just different content data.
I would ideally like a worksheet at the end of all the other worksheets
with each copied range pasted below the last.
I hope the is feasible as I have looked at the consolidation method and
is doesnt seem to apply here. All help is appreciated. Thanks!
Is there any way to compile the contents of all the sheets on a
workbook into one sheet where the range is to be copied is A45:T500 on
each worksheet - and each worksheet is named by date e.g 06-02-06,
07-02-06 etc. The columns and format are the same throughout the
workbook, just different content data.
I would ideally like a worksheet at the end of all the other worksheets
with each copied range pasted below the last.
I hope the is feasible as I have looked at the consolidation method and
is doesnt seem to apply here. All help is appreciated. Thanks!