new unique sheet each day......
Hiya again,
Our MRP system pumps out each day an excel sheet showing all of the previous days transactions. Currently I copy and paste this into a file which is a pain. The file which is created always has the same name "tranday.xls"
What I would love to do is each day open the same file which at the push of a button, open up "tranday.xls", copys the data and paste it into a new worksheet named "ddmmyy"
This should hopefully give me a worksheet for each day of all of the transactions that take place.
Can anyone help?
Hiya again,
Our MRP system pumps out each day an excel sheet showing all of the previous days transactions. Currently I copy and paste this into a file which is a pain. The file which is created always has the same name "tranday.xls"
What I would love to do is each day open the same file which at the push of a button, open up "tranday.xls", copys the data and paste it into a new worksheet named "ddmmyy"
This should hopefully give me a worksheet for each day of all of the transactions that take place.
Can anyone help?