Making WS1 look at WS2

[scottb]

Please bare with me while I try to explain this.

In Worksheet 1 I have a price list with a few hundred items.

In worksheet 2 I want to show only the items from WS1 where I have chosen a quantity greater than 1.

Is there a piece of code I can put somewhere in WS1 that will run automatically or I can click on to run this requirement.

I know you can put code in WA2 to only show the items that have a value greater than 1, but this is not what I want to do.

Does this makes sense.

Thanks

[jj72uk]

Can you post an example, so I can see column references in WS1

Should be a simple macro

[scottb]

Hi, I will aim to send this tomorrow as I am just changing it.