Selecting specific data to form a graph.

[Robbie]

I have up to 150 stock numbers which correspond to a product made. I
currently have a daily sheet which tells me the yield of each stock
number made the previous day. I need to write some VBA which will take
each stock number and give all of the yield fiqures for a month in one
column, so that I can then create a graph. Does anyone have any
suggestions for making the code as small and simple as possible?

 

[Tom Ogilvy]

I would use the Vlookup formula and gather the daily data in the columns
adjacent to your list.

=Vlookup(A1,'C:\MyDailyData\[20040701Output.xls]Sheet1'!$A$1:$B$150",2,False
)



Then you could sum across those columns and graph the sum column.

Another possibility is to look at the consolidation entry under the Data
menu.

 

[Jon Peltier]

Another approach would make use of pivot tables.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______