hi
i have a data valisation in sheet " Data Entry" in C3 it is dynamic from AD7 " =OFFSET($AD$7,0,0,COUNTA($AD:$AD),1) " , can be any number of rows.
VB should be in this order
if A3 is " (ALL)" then A3 = AD8 then -- run Option Explicit Sub ShowList() ---- wait 10 seconds -- then Print -- next go to AD8 , A3= AD8 , run Sub Showlist() , Print ......... so on, if the cell is empty stop.
i will creat a button to run that macro, like Sub Print()
Any help please.
mostakim
Bookmarks