View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
moglione1[_8_] moglione1[_8_] is offline
external usenet poster
 
Posts: 1
Default Loop through drop down list


Hi All,

I have a drop down list in Cell A3 of a spreadhseet. This list contain
the names of all my customers.

Is it possible to loop through this drop down list (created vi
DataValidation) and for each name in the list run a macro called d
all and save the file under the name in the drop down list. I.e. Eac
name in the drop down list will have its own workbook.

Thank you for your hel

--
moglione
-----------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...fo&userid=2641
View this thread: http://www.excelforum.com/showthread.php?threadid=52569