Repeat item 12 times for 12 months

**BHammy** · 10-04-2012, 11:36 AM

In column H, I have a list of part numbers. 100-00-001, 100-00-005, etc.

In column B, I want to list each part number 12 times so I can load in one value per month. So the value in H3 will go in B3 through B14, H4 will go in B15 through B27, etc. There are hundreds of items so I need to automatize it, not do it manually.

How do I do this?

**Jakobshavn** · 10-04-2012, 11:53 AM

How about this tiny macro:

Please Login or Register  to view this content.

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To use the macro from Excel:

1. ALT-F8
2. Select the macro
3. Touch RUN

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macros must be enabled for this to work.

**BHammy** · 10-04-2012, 11:54 AM

Thank you! I'm going to try this now!

**Jakobshavn** · 10-04-2012, 11:55 AM

Good Luck!

**Ace_XL** · 10-04-2012, 12:00 PM

A formula perhaps..

=INDEX($H$3:$H$14,INT((ROW(A1)-1)/12)+1,)

**BHammy** · 10-05-2012, 12:01 PM

This is excellent - thank you both! I'm going to mark this thread resolved.

I have a similar question I just posted -- will try to figure out how to apply these principles to it. You are invited to give your ideas on it as well:

http://www.excelforum.com/excel-gene...html?p=2957458