Hi Jon

Why are you doing the filtering on a copy? Why not just filter the original?

If you do want to copy all data to another sheet, then on Sheet2 in cell A1
enter
=Sheet1!A1
Copy across for as many columns as required.
Copy this range of cells down as far as you need.
Everything entered on Sheet 1 will automatically be replicated on sheet2

Regards

Roger Govier


Jon Mckay wrote:
I want to copy data from my primary worksheet (which will be modified
frequently) to other my other worksheets (which have filters applied to the
data) I want these to be updated automatically.

I have already set up the filters on the other worksheets.

To put you in the picture, it is for a stock room system, with the current
stock in the primary sheet and the stock per shelf in the other worksheets.

Thankyou Your help is warmly welcomed!