Rob Hanson helped me with a DB Issue with Excel. I'm trying to build a model that uses a DB; and while Access would be a better choice, Rob showed me how I could take a 4 column DB and by using the "FORMS" function ALT.+D+O in Excel 2010, add to and maintain a DB. I have two questions;
1.) Can I use this tool via a simple Macro (perhaps a recorded Macro for bringing it up)? -- Example please
2.) Is there some macro code that can insure the order of the DB is automatically maintained? That is, auto sorted (when a new record is entered) where Col. 1 is the primary, then by Col. 2, then by Col. 3?
Much thanks in advance,