I've got some homework for my Excel for Engineering class, and I'm stuck on how to finish it. It consists of three sheets. The first one has you enter in the name of the hard drive, the size of the hard drive, and the price of the hard drive. I then have a macro set up to a button that adds this information to a list of all the other hard drives entered, and calculates the price per gigabyte for that particular hard drive. So basically every time you enter information for a new hard drive the list becomes one row longer.
My question is how do I make a macro that will automatically take every entry in the list from the top to the bottom, and graph the price per gigabyte of each one. It also has to keep updating the graph each time another entry is made to the list.
I have only used the macro recorder in Excel, and don't know how to program VBA; however, if you can give me exact commands I do know how to cut and paste very well.
2007-10-30
16:05:03
·
2 answers
·
asked by
Woden501
6