merging sheets
 

hi membes

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


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=568769

merging sheets
 

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


with @tiscali.co.uk


"b166er" wrote in
message ...

hi membes

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


--
b166er
------------------------------------------------------------------------
b166er's Profile:
http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=568769