I'm guessing if this is possible, someone's already explained the how-to's in another question's solution or on another website. If anyone knows where I can find my solution, a link would be greatly appreciated!
So... here's the problem:
For the sake of batch data entry into one of our coporate databases, I've built an Excel spreadsheet that uses VBA macros to allow the user to customize the layout of the spreadsheet, validate their input, and upload their validated information as a CSV file to an ftp site. (From here the data is pulled into our database through a series of automated processes.) This functions perfectly, however, it is huge and more importantly, it's very very very slow, especially the validation process! Validating entries in 150000+ cells is not a pretty sight!
So, am I just wishful thinking, or could this be possible? Anyone see instructions on how to do this on this or any other site?