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.
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.