Hi Everybody :-)

What i am lookin for is help\guidance with loop macro.

What i need is for the macro to run throug the data held in a number o
rows then place it in to seprate workbooks.

i.e. copies data from first row into workbook 1.xls then copies secon
row to work book 2.xls this goes on till row 8 and that row has bee
copied to 8.xls then 9th row would be copied to 1.xls etc. up unti
all the data has been placed in to seprate workbooks. (its a bit lik
one for you and one for me one for you...)

Can anybody give me any help or point me in the right direction.

Regards
Pau

--
Message posted from http://www.ExcelForum.com