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