Hi guys,
I have successfully created a very basic macro on my Excel 2011 version (on a Mac).
I did the following:
1) Record
2) Created my date list
3) Used specific formulas
4) Colour coded results
5) Stopped recording
6)Deleted cell information (to save macro template, but not data)
7)Saved doc as a Macro template
8) I import a CVS file into my new Macro template and so far, so good
However, when I try and run the Macro, it appears with the old cell information (cell information which I delete before saving Macro template in step 6).
I know my Macro doc is good because the macros are enabled and it appears empty when I open it. However, when I run a macro with imported (new data), it keeps on getting replaced by the old data that I deleted.
Any help would be greatly appreciated!
Thank,
Steffan
Bookmarks