Autofill Column B based on Column A entries

I have a Listbox that outputs data to Column A. Is there a way to auto populate Column B with 4 items for each Entry in Column A? The 4 items that will populate in Column B will always be the same.

I have attached an example to better explain what I am trying to describe.

Thanks.

Excerpt from the forum rules "tips" section:

"If you want help with Excel, post an Excel file, not a picture, Word file, PDF, or text file. Nobody's anxious to type data from a picture into a spreadsheet as a prelude to helping. To attach a file, [click GO ADVANCED if necessary] push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button."

Are you trying to get your POPULATE button to do more?

Since all we have to go on is what is in the lists page so far, mockup some sample "results" in your sheet of what you WANT to happen when you select 3 or 4 entities. Make sure your sample shows exactly what you want, and if it's not clear where the information you mocked up came from, explain it.

I think I might have figured out what you want. Try changing these macros:

Please Login or Register  to view this content.

I've added a box to your form where you can enter how many products out of the product list you want to be listed.

Please Login or Register  to view this content.