Hi Guyz!!!
I have a worksheet having different column for e.g
Column A (CODE) Contains - WC1, WC2, WC3
Column B (CATEGORY) Contains - PL, SA1, SA2
Column C (QUANTITY) Contains - 100, 200, 300,
Column D (UNITS) Contains - KG, ML, NO
When i run a macro first it should ask to enter CODE (where i will enter WC1) where the worksheet will filter all the rows which contains WC1.
Then by click GENERATE button it should copy entire row to another sheet which contains PL in it.
Please if anybody can help me on this...Thanx