Printing same sheet with multiple values from other tab

[Justhavinaltlfun2002]

I have a main sheet named "EntryData" that changes based on the value selected in a dropdown box named "DropDown1" located on "EntryData".
I am needing to be able to print the "EntryData" sheet for each value presented in "Dropdown1" with out any user interaction other than pushing a button.

Is this possible?
Thanks for any help
RS

 

[Wookiee]

I have a macro that does something to that effect. It uses a named range as the source for all the items in the list. If you have the items from Dropdown1 in a named range, you can do that fairly simply like this:

Sub JustHavin()

Dim rngCell As Range

'Loop Through Names And Print Cycle Time Charts
For Each rngCell In Range("nrDropdown1")
   
   Range("A1") = rngCell.Value
   
   ActiveWindow.SelectedSheets.PrintOut _
      Copies:=1, Collate:=True

End Sub

 

[Justhavinaltlfun2002]

Thanks Wookie,
Having issues running this. I have a defined name range as you suggested "nrDropdown1" that gets its data from the "Clients" tab. $a$1$a$33.
From your code, I only changed the value 4th line to "A33" (as this is the cell, on the sheet named "EntryData" that contains the Dropdown box). I also added a Next statement to end the "For" statement.

However, when I try to run this I get a RunTime '1004' - Method "range of Object" '_worksheet' failed.
I have copied the modified code below.

********************************************************
Sub (jushavin)
Dim rngCell As Range

'Loop Through Names And Print Cycle Time Charts
For Each rngCell In Range("nrDropdown1")

Range("A33") = rngCell.Value

ActiveWindow.SelectedSheets.PrintPreview _
' Copies:=1, Collate:=True
Next
End Sub

 

[Justhavinaltlfun2002]

Skip it Wookie....figured it out. Its working nnow
Thanks again for your help

 

[Wookiee]

Skip it Wookie....figured it out. Its working nnow
Thanks again for your help

excellent! glad to hear it.

and apologies for missing that NEXT statement; i copy/pasted from existing code and didn't test my code before posting.