0

Is there a way to automate autofill in Excel with say a function or something along those lines? I need a function I currently have to autofill down a certain number of rows depending on the user's input but all I can find on google says to use the autofill handle which will not work for what I need. Any help is appreciated.

Can I have a function autofill down a certain number of rows automatically? As in, when a user inputs a number of rows, it automatically fills the function that amount of rows.

DreamsOfElectricSheep
  • 3
  • 2
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Sep 06 '21 at 15:38
  • Is that more clear? I've been struggling with this for a while so I'm having difficulty putting the issue to words. – DreamsOfElectricSheep Sep 06 '21 at 15:47

1 Answers1

1

Maybe this works:

enter image description here

SEQUENCE() is a spill formula, enumerating a desired sequence.

IF simply test if an item in the sequence array is less than desired range if yes it will perform the formula.

another option is to use Row() in place of sequence, but it may be harder to work with (especially if someone accidentally inserts rows)

If this isn't what you are lookong for then clarify your question.

gns100
  • 991
  • 5
  • 5
  • That is essentially what I was looking for, that technique helped me get part of it done. I wound up just using the autofill drag handle and hiding all data further down from the number of rows the user input. Thank you for your help. – DreamsOfElectricSheep Sep 06 '21 at 22:07