Fill a spreadsheet automatically after one cell is input

  • Thread starter Thread starter Justin
  • Start date Start date
J

Justin

Okay, I know how a normal autofill works. However, how do I do it in
this case?
Spreadsheet has formulae. User makes a selection and VLookup instantly
populates the rest of the table with information. So how do I
instantly populate said spreadsheet where it autofills the row once it
is selected. An IsBlank() formula works in theory, but then I have to
autofill the first 500 rows or so. I want something that just
dynamically moves to fill the row as the user gets to it.
Is it possible?
 
For what you are stating I think that you are looking at some way or adding
the extra data once the user has added some information.

I can only suggest VBA macros.

1. Use a userform in VBA and once the user has entered the data process it.
2. Use a worksheet event to pick up a change and process accordingly.
 
Back
Top