Hi All,

This has really been bugging me for the past few hours. Any advice/suggestions would be highly welcome. I use Excel 2010.

In short, I have a big spreadsheet with data regarding employees. Column A: First Name, Column B: Surname, Column C: Payroll no... etc. Column L is Region (South, South East etc.).

I have previously created several other worksheets in the same workbook based on the region but I did that by simply filtering by region and then copy+pasting it into the relevant sheet.

Is there a way of creating a link between the master and sub-spreasheet based on the region? I would like new employees to be automatically added to their relevant region sub-sheet as they are entered into the master.

Thank you in advance, please help!

Vas