Forum Discussion
Add row data when new sheet is created.
I haven't found an answer even close to what I'm looking for in my searches so here goes:
I have a project task managing workbook where Sheet 1 is an overview of all the projects and then each project has it's own sheet.
I have set up sheet 1 with a table displaying information linked from the other sheets. Every 5 rows is a display of a project name and it's top 3 tasks. however every time I add a new project (create a new sheet) I have to add the new rows manually by copying a previous set of 5 rows and editing all the linking formulas to the new sheet.
Is there a way I can auto-generate a new set of rows into the table on Sheet 1 every time I add a new sheet?
1 Reply
HI Darcan,
Keep the file on OneDrive and you can use Power Automate to which I believe can easily solve your query by just adding the flows
Regards, Faraz Shaikh