charts - VBA Data Validation from another worksheet -

I currently have 2 work sheets in sheet 1 and sheet 3 sheet 3, I have more than one publicly traded There are companies that are going to the first line under each company, I have a chart / graph name which I was able to find through another workbook relevant to the company.

In Sheet 1, I have a column for companies and a column for the graph, I want to create a drop down list which will allow a user to choose a graph and open it in PDF or extended version. How would I go about doing this?

sub-appendGraphs (dimmer), the target worksheet dim locator, set the RC = Sheet5 set as the source of the set target = sheet 1 as the control line = source.Cells (1, Columns.Count) feed .End (xlToLeft) for .Column I = 2 control to collect the 'wire each column line and datavalidation RC = source.Cells (Rows.Count, i) .End (xlUp) For archived in tempList Line ReDim tempList (RC to 1) = 2 UBound (tempList As String n) tempList (N) = source.Cells (i, n) .Value (findRowB (source.Cells (with target.Cells to 1, i). value, sheet 1), 10) .Validation .Delete .Add type: = xlValidateList, AlertStyle: = xlValidAlertStop, _ operator: = xlBetween, Formula1: = tempList .IgnoreBlank = true .InCellDropdown = true .InputTitle = "" .ErrorTitle = "" .InputMessage = "" .ErrorMessage = "" .ShowInput = True .ShowError = True end with Next

end sub

The

  function findsRowB finds a special row in the form of an integer (string, as a worksheet As Akalpik Y x) to start as worksheet writing values ​​in the range dim wbsheet as dim expectedRow, if Y is nothing then set wbsheet = ActiveSheet Else wbsheet = y end set, set ExpectedRow = wbsheet .Range ("C: C"). Find (what: = X, looking: = xlValues, lookAt: = xlWhole) findRowB = expectedRow.Row  

end function

Nobody will do that for you. I just google every part personally, here I will start you.

Create a drop down,

Link it,

Save it as a PDF,

Google is your friend !

or use a macro record.

Feel free to ask questions.