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" <[email protected]> wrote in message news:[email protected]...
> > 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" <[email protected]> wrote in message news:%[email protected]...
> >> >I will answer you when I come home from work
> >> >
> >> > --
> >> > Regards Ron de Bruin
> >> > http://www.rondebruin.nl
> >> >
> >> >
> >> > "SJC" <[email protected]> wrote in message news:[email protected]...
> >> >>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" <[email protected]> wrote in message news:[email protected]...
> >> >>> >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.
> >> >>> >
> >> >>>
> >> >>>
> >> >>>
> >> >
> >> >
> >>
> >>
> >>
>
>
>
Bookmarks