Rearrange data for printing

T

tim

I have a spreadsheet with records and 3 header rows (Date, Count and
Sum). I need to be able to print a record and can't figure out write
a macro to format the data. (Actually, I can record macros, but I
don't understand VB so as to "write" a macro.)

It looks something like this:

A B C D E
1 Date 2-Jan 3-Jan 4-Jan 5-Jan ..->
2 Count 1 1 1 2
3 Sum 50.00 40.00 30.00 45.00
4
5 Name
6 Bill 50.00 30.00 20.00
7 Sam 40.00 25.00

I need to format it for printing like this on another sheet

A B
1 Bill
2
3 2-Jan 50.00
4 4-Jan 30.00
5 5-Jan 20.00

or

A B
1 Sam
2
3 3-Jan 40.00
4 5-Jan 25.00

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top