Hi SJC

Can you send me the workbook private then I will look at it tomorrow

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


"SJC" wrote in message ...
I'll tell you everything that I have in hopes to answer your question, as I
am still kind of new at this. In my workbook, I have two spreadsheets. My
'Data' sheet holds all of my data. I then have a 'Report' sheet which
produces a one page report from my data which includes a table and two
charts. My hope for this was to create a standard report that would
automatically update for each of my 300 facilities. So on my report
worksheet, I have used OFFSET formulas to retrieve the data from the 'Data'
worksheet, and a data validation listbox to choose which facility to display.
On the 'report' worksheet, column J is my reference list for the data
validation list. This list obviously was used to create the data validation
listbox, and to compile this list, I just pasted links from the 'Data'
spreadsheet. So now I am trying to create a macro which will go through my
data validation list and print one report for each facility. When I view
each report on the spreadsheet using the data validation listbox, the report
appears fine. However, when I run the sub to print, it produces one report
for each facility, but in many reports, no data is present. In other
reports, it appears fine. I hope I have not been too confusing, any clues on
how to fix this?

"Ron de Bruin" wrote:

I was thinking that you use Vlookup formulas in your sheet with as lookup value
the Data Validation cell.

how do you update the cells when you change C6

BTW
list of facility numbers in row K that I used the for the data validation
I see J in the code now ?

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


"SJC" wrote in message ...
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.