I could do with some help, i've created a short macro that basically rearranges and calculates a large table of data and then saves the new file. Is there anyway to code the macro so that it saves the new file as the old file name . Currently it always saves the output as book 1. Which is annoying as i have to run this file several times.
Any help/Advice would be much appreciated.