Macros: Copying from different document, saving in multiple forms
Can I do the following within a macro:
1. Open a second Excel document to copy a column from it; return to the
working document, paste the column of data in it.
2. Run a variety of calculations (already doing this).
3. Eliminiate worksheets within the primary document (with useless
information).
4. Add a worksheet so that I can save once in Excel format, once in text
format and once in csv format.
Thanks.
|