Hi,
I need help creating a macro that loops the calculations. Currently I have a drop down list in a sheet and I have a macro that picks each individual name calculates the results and then copies and pastes the 2 cells that I need in to a table. This repeats itself dozens of times. I need help that the macro should automatically choose the next name in the table, paste it in the drop down menu, calculate, and paste results in the table, and of course repeat. I’m attaching part of the macro, if anybody can take a look it would be really appreciated.
Bookmarks