In my excel document I am trying to copy cell rows when the cell condition is met.<?XML:NAMESPACE PREFIX = O /><O:P></O:P>
<O:P> </O:P>
For example: If cell A1 has a drop down menu, ‘Supplier 1, Supplier 2, Supplier3..etc), If I select ‘Supplier 2’ then I would like all the cell rows to copy into a new worksheet. However, if I select ‘Supplier 1’, then it should remain in the original worksheet.<O:P></O:P>
<O:P> </O:P>
The drop down menu has a data validation, how can I now chose ‘Supplier 2’ and copy them all into a new worksheet so the new worksheet contains all of ‘Supplier 2’ details?
I would be greatful for your help
Amit
<O:P> </O:P>
For example: If cell A1 has a drop down menu, ‘Supplier 1, Supplier 2, Supplier3..etc), If I select ‘Supplier 2’ then I would like all the cell rows to copy into a new worksheet. However, if I select ‘Supplier 1’, then it should remain in the original worksheet.<O:P></O:P>
<O:P> </O:P>
The drop down menu has a data validation, how can I now chose ‘Supplier 2’ and copy them all into a new worksheet so the new worksheet contains all of ‘Supplier 2’ details?
I would be greatful for your help
Amit
