I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.

A macro would do fine--I guess I am just not sure how to set it up. I have a
list of facility numbers in row K that I used the for the data validation
list, which of course is on the same spreadsheet as the report that I want to
print. Any clue on how I would get started?

"Ron de Bruin" wrote:

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.

I will answer you when I come home from work

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
A macro would do fine--I guess I am just not sure how to set it up. I have a
list of facility numbers in row K that I used the for the data validation
list, which of course is on the same spreadsheet as the report that I want to
print. Any clue on how I would get started?

"Ron de Bruin" wrote:

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.

Hi

Try this with D1 as data validation cell that update your other data
I use a sheet with the name Sheet1

Delete preview:=True when it is working like you want

Sub test()
With Sheets("Sheet1")
For Each cell In .Range("K1:K5")
'D1 is the data validation cell
.Range("D1").Value = cell.Value
.PrintOut preview:=True
Next cell
End With
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
I will answer you when I come home from work

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
A macro would do fine--I guess I am just not sure how to set it up. I have a
list of facility numbers in row K that I used the for the data validation
list, which of course is on the same spreadsheet as the report that I want to
print. Any clue on how I would get started?

"Ron de Bruin" wrote:

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.

Thanks for the code. Here is what I tried:

Sub test()
With Sheets("Report")
For Each cell In .Range("J1:J5")
.Range("C6").Value = cell.Value
.PrintOut preview:=True
Next cell
End With
End Sub

I ran the sub, and it did not pull the data for all of the reports as it was
supposed to. As background info, I have all of the data in another
spreadsheet within the workbook named 'Data', and I have it linked to the
'Report' spreadsheet. Then obviously the report changes by what name is
selected in the data validation list. Any clues on what I am doing wrong?

"Ron de Bruin" wrote:


Hi

Try this with D1 as data validation cell that update your other data
I use a sheet with the name Sheet1

Delete preview:=True when it is working like you want

Sub test()
With Sheets("Sheet1")
For Each cell In .Range("K1:K5")
'D1 is the data validation cell
.Range("D1").Value = cell.Value
.PrintOut preview:=True
Next cell
End With
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
I will answer you when I come home from work

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
A macro would do fine--I guess I am just not sure how to set it up. I have a
list of facility numbers in row K that I used the for the data validation
list, which of course is on the same spreadsheet as the report that I want to
print. Any clue on how I would get started?

"Ron de Bruin" wrote:

Hi SJC

You can do it with a macro.
Do you want that ?

Do you have a list with facility names on a sheet and use that
range for the Data Validation list ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SJC" wrote in message ...
I have created a workbook which reports facility data trends. I created a
standard report to report this data for each facility. To create each
facility's scenario, I used a data validation list with a drop box of
facility names to create a standard report for each facility. Obviously only
one report may be seen and printed at one time. Is it possible to print out
all scenarios in the validation list, or do I need to print each report one
at a time. Thanks in advance for any help.