transpose Rows to column

Originally Posted by mrice

Does your first sheet contain multiple rows of data and if so, how would these appear on the second sheet. Is it stacked below with a page break between each set?

Hi, yes there are many rows of data and you're right again that they'll need to be stacked on the second sheet with a page break.

Basically what it I need to do is at any time be able to sort the first MAIN sheet by the Service Date Month so that all the customers are listed by the month in which they require a service; run the macro to copy the sorted list to the PRINT sheet, then print off the pages that relate to the month I want.

Originally Posted by HSV

It’s a start.

Run the code in Sheets 'MAIN'..

Please Login or Register  to view this content.

If the code is good, change Range("C1") in Range("A1")

Okay thanks for this, we're on the right track. I managed to get the code in, change to A1 like you said, run the macro and it put the headings vertically like I wanted. I've added some spaces to the headings to make it clearer when it's printed and it still works. Okay so I added a few rows of information but the information does not appear on the PRINT sheet. See attached. Any ideas?

Thanks,
Gareth

Originally Posted by HSV

Gareth,

Something like attached file?

Hi, HSV, thanks but no, not like that. I have attached what I need. I can't have the PRINT spreadsheet the way you have it because I am limited to 256 columns. That would limit the number of customer records I can have.

Thanks again,
Gareth

Originally Posted by HSV

Now am i on the right track?

Yes that's it. Just one small thing and it'll be perfect. When you run the macro and it moves the information to the PRINT sheet, it puts in an extra row at the top of the sheet which throws the prints out by a line. I know I can just delete the line but if it's easy enough to have the information start one row up it'd be perfect. Thanks HSV, it's amazing what you guys know. I look at the macro code and just smile to myself because it's all so clever.
Gareth

Originally Posted by HSV

Gareth,

Glad to hear.

Add the second line in the code like this.

Please Login or Register  to view this content.

HSV is my hero.

HSV I want you to know I really appreciate all you've done on this. I'm very impressed. I'm not sure what I can ever do to repay you, but I'm based in the North West of England and have just started a fire protection company - if you think of a favour I can ever do for you, just ask.
Thanks, Gareth

Originally Posted by HSV

That’s enough Gareth

I hear you, but still, thanks.