merging sheets

[b166er]

hi membes

how can i merge the data of 15 different worksheets into single shee
in the same workbook data is almost of 5000 rows in each workboo

 

[Sandy Mann]

You could record a Macro to do it but 15 x 5,000 = 75,000 and there are only
65,536 rows in a spreadsheet, well until XL 2007 that is.

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk