I am trying to write a program that does the following: a)copies data from two different workbooks into one sheet, b)invert one the columns (most like by sorting it by using an adjacent column of sequential numbers) and c)makes a chart. Is this possible? If I can't copy from two different workbooks, thats okay, but the most tedious part of analyzing my data is the inversion.
By the way, I have a little experience with C++, but only one class while an undergraduate. So the simpler the better. Thanks!
2007-02-06 05:52:08 · 2 answers · asked by mbla06 1 in Computers & Internet ➔ Programming & Design
have a look at the website links below...
I've been developing in MS Excel VBA / VB6 / VB.NET & C# for 5 years or more, and these are the sites I use for Excel VBA.
Hope that helps
Philip
2007-02-06 07:37:05 · answer #1 · answered by Our Man In Bananas 6 · 0⤊ 0⤋
Try "recording" macro whilst you do what you need to do (or as near as possible), and then have a look at the macro commands and tweak them - if you have specific questions on the commands drop me an email.
Be sure to try all this out on a "test" spreadsheet rather than something valuable!
2007-02-06 06:00:36 · answer #2 · answered by Anonymous · 1⤊ 0⤋