I'm a newbie at VBA and trying to learn how to get a macro to fill out a list for me. I keep running into errors. Here's what I'm trying to do:
I have 2 worksheets: Names and Data
Names is a worksheet with multiple data validation boxes
Data is a list of all those names with counts of how many times they are listed in the Names worksheet
If cell A1 is blank, I want to cycle through the names in the data validation box based on the lowest corresponding value in the Data worksheet. Then move on to the next cell and look for the same things
What code will run through these cells looking at the values in the dropdown boxes?
I have 2 worksheets: Names and Data
Names is a worksheet with multiple data validation boxes
Data is a list of all those names with counts of how many times they are listed in the Names worksheet
If cell A1 is blank, I want to cycle through the names in the data validation box based on the lowest corresponding value in the Data worksheet. Then move on to the next cell and look for the same things
What code will run through these cells looking at the values in the dropdown boxes?
