Hi Geeks, interesting tool those Macros. I am using Mac Excel 2008.
- The macro function appears not to be working is that correct anyone?
- The way the example is described, is only useful in the case of large numbers of identical data sheets with numbers occupying the exact same field positions, is that correct?
- An alternative way of tackling this would be to set up an excel sheet as per the example (without recording), save it and protect it except for the data fields, in a fixed location as a template, and then record a macro that opens the (rough) data sheet whenever it comes in, copy-pasts these into the template, do a 'Save As' and stop recording. Is that right?