Hi, I have a data table in Excel. I have a task of needing to add a drop down list to a specific column called Mandatory Selection. This list should have 3 options Agree, disagree, and Agree with Fee. This drop down list should be applied to all rows in this column. Then I need to loop through another column called Vendor names and each full row with the same Vendor name needs to be extracted and saved to it’s own new excel file named after that vendor name.
Welcome to the community
You need to use macro to do that…there is no activity as such…
Cheers
Great and how would I do that?