Forum Discussion
Copy data to another Workbook automatically
NikolinoDEIf you have the file saved in a SharePoint library, you should be able to use Power Automate to move rows from one spreadsheet to another based on a status column. You could set the workflow to run on a schedule that looks for all rows in the table set to a "Hide" status, create them in a new workbook stored in the same document library and finally loop back round to the original to delete.
Duane Bergh Hi Duane,
Thank you for getting back to me. I think I understand what you are suggesting but I do not need it to delete anything. I just want the information I put in columns K to AB to be copied exactly into a separate workbook for my staff to view. The original document holds sensitive data in columns A to J that I don't really want them seeing.
As I then update the data in columns K to AB in the original I would like the data to automatically update in the secondary workbook that my staff have access to.
Sorry if I am not being very detailed, I have never tried to do anything this advanced before.
Thank you,
Laura
