Need to add 12 rows for each item

  • Thread starter Thread starter bizee
  • Start date Start date
B

bizee

I have a list of items, each of those now needs 12 rows (one for each
month). How can I do this without manually doing so. The list of
items is well over 200.
 
A description of your layout would be helpful.

In general, you do the following:
1. Calculate the sum for one item, as in: =sum(a2:l2)
2. Drag this cell down as many items as you have. Excel will automatically
adjust the calculation for you. The easiest way to drag is to grab the fill
handle (the black box on the bottom right of the cell), and drag is as far
as you need. Then release the cursor.

Regards,
Fred
 
Not quite sure, but perhaps this angle ...
Assume your source list of items is in A2 down
You could place this in any startcell, say in E2:
=OFFSET($A$2,INT((ROWS($1:1)-1)/12),)
Then just copy E2 down as far as required to exhaust the source list
Col E will repeat each source item 12x as you copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top