T
Top Spin
I would like to create a little worksheet to do some calculations on
some sample data. I would like a section of the worksheet to act like
a "subtable" with one row for each set of sample data, headings across
the top, the ability to add new rows at the top, and with the totals
also at the top.
For example, if the subtable starts like this:
n Head1 Head2 Head3 ...
Tot total1 total2 total3 ...
1 data11 data12 data13 ...
I would then like some way (ideally a function key or keyboard
shortcut) to add a row BEFORE row 1 so that it looks like this:
n Head1 Head2 Head3 ...
Tot total1 total2 total3 ...
2 data21 data22 data23 ...
1 data11 data12 data13 ...
and have all of the totals updated. I would like this to continue with
the older rows getting pushed down each time new data is entered.
Can someone point me in the right direction to get started?
Thanks
--
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
LAN: P2P with an HP Vectra workstation
Email: Usenet-20031220 at spamex.com
(11/03/04)
some sample data. I would like a section of the worksheet to act like
a "subtable" with one row for each set of sample data, headings across
the top, the ability to add new rows at the top, and with the totals
also at the top.
For example, if the subtable starts like this:
n Head1 Head2 Head3 ...
Tot total1 total2 total3 ...
1 data11 data12 data13 ...
I would then like some way (ideally a function key or keyboard
shortcut) to add a row BEFORE row 1 so that it looks like this:
n Head1 Head2 Head3 ...
Tot total1 total2 total3 ...
2 data21 data22 data23 ...
1 data11 data12 data13 ...
and have all of the totals updated. I would like this to continue with
the older rows getting pushed down each time new data is entered.
Can someone point me in the right direction to get started?
Thanks
--
PC: HP Omnibook 6000
OS: Win 2K SP-4 (5.00.2195)
LAN: P2P with an HP Vectra workstation
Email: Usenet-20031220 at spamex.com
(11/03/04)