Hello all
I have a Main worksheet which contains data in 4 columns & 9 rows. First column contains numbers 1,2 & 3. What is want is this :
I need the DO button in the worksheet 1 to do the folowwing procedure.
The row containing the value "1" in Column A has to be copied to Type 1
The row containing the value "2" in Column A has to be copied to Type 2
The row containing the value "3" in Column A has to be copied to Type 3
When in enter new data in worksheet Main, and then click the DO button, everything in the worksheets Type1, Type 2, Type 3 have to updated.
Can someone show me an example??
Thanks.
Attached is my Test Excel sheet
Bookmarks