I’m trying to do something in excel which I’m not sure it’s capable of.
I have a spreadsheet that has two tabs.
The first tab is the ‘top line’ data that shows the order details. The second tab holds the orderlines. The two are linked by a sequence number.
On the second tab I want to:
- Insert a two row everytime the sequence number (column A) changes.
So if it is like this
23
23
24
25
25
25
26
27
I want it to be this:
23
23
24
25
25
25
26
27
I then want it to total the column J in the second spreadsheet based on the sequence number like this:
Column A Column J
23 2.5
23 2.6
5.10
24 6.5
6.5
25 6.00
25 7.00
25 .50
13.50
I then want it to take the totals in column J and put it in the first tab in column S based again on the sequence number.
Am I asking too much?