Thank you this solved greatly the creating the files.
sorry I am learning how all these buttons works.
still having the issue when the file is created in those places there used to be a formula now gets #Value. the figures in those cells wont be pasted as values.