That is a very generalized question, and I can only provide a very
generalized answer:
Auto populating ranges of cells in response to an action, such as a custom
menu choice or in response to clicking a control button or performing an
action on a control in a user form is normally handled with custom Visual
Basic for Applications (VBA) code [also known as macros] within the workbook
in some fashion.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.