Auto populate cells based on the number in another cell

Wonderingaboutexcel - Jun 22, 2016 at 08:42 PM

I was wondering if it's possible to "tell" excel to Auto fill in a row of cells with specific text, based on a value in another cell. For example, I have a cell containing the number of months (3) and would like excel to auto populate a row with "Month 1" "Month 2" and "Month 3" so that data can be filled in under those headings. If the cell changes to 2 I would then like to have excel auto populate the row with "Month 1" "Month 2". Trying to avoid a long IF statement. Any ideas would be much appreciated. Many thanks!