Concatenation and new rows

Hi Alex

Thank you for your question regarding adding new rows to a number of worksheets.

The best way to achieve this is to:

- Firstly group the sheets you want to add the new row to i.e if sheet 1 to sheet 5, select sheet 5, hold down the shift key and then select sheet 1 (this will select all the worksheets in between)

- On sheet 5 (the latest worksheet) insert a new row between row 5 & 6, entering the relevant info.

Check the previous worksheets, the new row should have been added to all datasets.



I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer