I have a worksheet "ALL KEYS" that has data that are contained within a list. I have another sheet "KEYGRAPH" that has row lettered as A,B,C...The columns on Keygraph are 1,3,5,7... Some of the graphs will be 2,4,6,8... I want to create a "key graph" worksheet that is constructed Totally using the information from the "ALL KEYS" worksheet. I have a macro that is called "CREATE KEYGRAPH " that sortof gives an example of what i want but is far from ok. I know just a little vba but only enough through trial and error to put together other macros i find to create anything. I have attached the file for you to look at. Any help would be appreciated. Thx