Hi Guys
Thanks for your replies, VBA is beyond me at the moment but I wold like to learn more about this not just for cnc.
Anyway, I found some info in this forum which pointed me in the right direction for what I am thinking, it's simple really, just build up a text string in column A, make column B your calc for X, C your calc for Y etc.
Make column A ="G01X"&B1&"Y"&C1&"Z"&D1&"F50", and so on, drag it all down, then you can paste column A into Note pad and finish of the rest. I guess you could build quite sophisticated spreadsheet if you wanted.
Cheers
Nigel