Producing report from one line of spreadsheet

[Raykeith30]

Hi all,

I have a problem whereby I need to find a quick way to produce 5000 odd printouts of rent from one spreadsheet. The spreadsheet I have currently details the rent for about 5000 tenants of an organisation, like so:

A B C D E
Name Address Core Rent Services 1 Services 2....etc.

There are about 5000 rows on the spreadsheet, all with the same format. Is there some kind of macro out there, which will print out on a separate page the contents of one row, ie. one tenant? I've tried creating one, but I can't get it to 'collect' the details of the row I specify, it only does the one that I was 'collecting' when I recorded the macro. Is there any way round this or will I have to use some other software package?

Thanks in advance,
Ray.

[robert111]

edit the macro and have a counter in the macro num=num+1

then go to cells(num,1) or is it (1,num) to get your data