Morning all,
I am new to using Excel and I need some guidance.
I am using Office 365 on a Windows 11 PC.
I have attached a sample of the worksheet.
I have an incoming register and I need to create data packs from it.
I need to create a sheet(report) for every row in the register, with specific data from that row. However, every time I duplicate the sheet, I have to manually update it.
Every time I duplicate the report I want to populate the required cells automatically. so if I duplicate report 1 then I would need report 1 (2) to populate the info from the line PF-02 and so on and so on
As you will see in the worksheet the first couple of reports I had to manually insert the cells I required copied across to the cells.
Is there a way to copy the sheet and have the formulas update automatically?
Thank you in advance for your assistance
I am new to using Excel and I need some guidance.
I am using Office 365 on a Windows 11 PC.
I have attached a sample of the worksheet.
I have an incoming register and I need to create data packs from it.
I need to create a sheet(report) for every row in the register, with specific data from that row. However, every time I duplicate the sheet, I have to manually update it.
Every time I duplicate the report I want to populate the required cells automatically. so if I duplicate report 1 then I would need report 1 (2) to populate the info from the line PF-02 and so on and so on
As you will see in the worksheet the first couple of reports I had to manually insert the cells I required copied across to the cells.
Is there a way to copy the sheet and have the formulas update automatically?
Thank you in advance for your assistance