supershot Posted February 21, 2012 Share Posted February 21, 2012 Hi everyone. I'm working on a project to practice stock trading. Before I jump into the real thing I wanted to practice on a game that I already play somewhat. Now What this workbook does so far is extract the prices of items daily using web queries. Then every day at the end of the day I have to MANUALLY press CTRL + U to run a macro to store the end of day prices to there respective areas in the workbook. This is where I am so far. What I'm currently trying to do is make a drop down menu on the first sheet so I can Look up an Item and it would paste what I have from its section on the second sheet. Now I know how to make the drop down, but once I have the item selected in the drop down, I don't know how to have Excel paste the items info from a different sheet to this page. Here is a picture of what I needed pasted over to the first sheet. I don't need to paste the graphs just the information. http://i1028.photobucket.com/albums/y348/Num1Midget/Format.png There's another thing I'm stuck on but I'll leave it at that for now I couldn't upload it it said invalid file Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.