Macro to save worksheet doesnt save correctly

Hi guys ,

Ive managed to make my first macro. It is a button which when pressed saves 10 pages of worksheet data that is filled in manually and puts it in a file, it then deletes all the data on the 10 forms so the worksheets are ready to be manually filled in on the next job.
The problem is that after I press the button it moves the filled in work sheet into the file ok and it stays there as well as long as when shutting off the original worksheet I select don't save.
If I select save then the sheets that have been sent to the file location end up blank.
This could be a real problem because it can take days to fill in the sheets. Any help would be much a[ppreciated

Hi thanks for the reply, the sheets do have formulas on them and it is picking the id number from a cell on the page when it is saved.
This is the macro

Please Login or Register  to view this content.