HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET

[aysenboy]

f.e. there is mutible sheets in one workbook and there is some data. I must
to copy then past to merge all sheets data into one sheet. Ä°s there a
function or menu or button that i can merge all sheets to collect into 1
sheet.

 

[NoodNutt]

G'day Aysenboy

This link will get you started in the right direction.

http://www.rondebruin.nl/copy2.htm

HTH
Mark.

 

[Ron de Bruin]

Hi aysenboy

You can use a macro to do this
http://www.rondebruin.nl/copy2.htm