Populating a list based on a specific value

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm trying to get a macro for populating a specific list based on a specific value entered in the cell next to it. part of the problem is that the population would need to be going vertically and would therefore insert rows into the workbook with specific values in them. if i was looking for this to be horizontal i would simply do a choose/match formula (as i have another list that's doing the same thing and for that, because it's horizontal, i'm able to use the aforementioned formula), but for vertical, i'm stuck.

pretty, please, help

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too