Forum Discussion
Copy sheet to another workbook
For ms office 365, how I can auto copy one sheet data to another workbook ? I am a manager. I have shared a workbook having multiple sheets to my colleagues. They update it daily. One of the sheet d...
You could try using a VBA macro or a Power Query to automate the process of copying the data from the shared workbook to your master file. You could also try using the Move or Copy Sheet command to manually copy the sheet from the shared workbook to your master file.
**Which of these options can/may/should be used depends on your digital environment (Excel version, operating system, storage medium, etc.) and partly also on the other users.
Hope I was able to help you with this info…if not please ignore the message.
I know I don't know anything (Socrates)
move or copy says my workbook isprotected