Can I automatically add lines depending on value in cell

[wildecoyote1966]

Is there a way I can put a value in a cell (say 88) and then have excel automatically add that many lines after the first.

For example

If cell A10 has 1/1/21 and I enter 88 in cell E5
can I get excel to add dates in column A for 88 days?

[AliGW]

Yes.

In A11:

=IF((A10+1)>E$5,"",A10+1)

Drag down as far as you want.

[wildecoyote1966]

Thank you again AliG. You make it sound simple lol

[AliGW]

Been at it for years!

[alansidman]

As an alternative, see if this VBA solution works for you

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button

[wildecoyote1966]

Thanks Alan but I get myself in a huge mess when I start trying to use VBA