Fill a spreadsheet automatically after one cell is input

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Justin - 15 Jan 2007 17:55 GMT

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?

Reply to this Message

Martin Fishlock - 16 Jan 2007 03:00 GMT

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.

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> Okay, I know how a normal autofill works. However, how do I do it in
> this case?
[quoted text clipped - 5 lines]
> dynamically moves to fill the row as the user gets to it.
> Is it possible?

Reply to this Message

Rate this thread: