VBA Multi-Column Filter, Copy and Paste on Separate Sheet

see attched file AMJ 14122.xlsm
save the file in your computer and open and ENABLE MACROS

sample data is in sheet1
in sheet 2 in cell A1 type any name in col 2 or 3 in sheet1.(if you type anything else a msg will appear that this name is not available)
do not delete entry in A1 of sheet2 overwrite
if the same value has to be added either type same value and enter or hit function F2 and hit enter key

the code is an EVENT CODE. It should NOT be copied in a standard module
if you RIGHT CLICK the tab of SHEET2 and click VIEW CODE you see the code
as this is already in the vbeditor of the file you do not any thing except CHANGING the value in A1 of sheet2

the code is also repeated here for others

Please Login or Register  to view this content.

see attached file AMJ 14122.xlsm
save the file in your computer and open and ENABLE MACROS

sample data is in sheet1
in sheet 2 in cell A1 type any name in col 2 or 3 in sheet1.(if you type anything else a msg will appear that this name is not available)
do not delete entry in A1 of sheet2 overwrite
if the same value has to be added either type same value and enter or hit function F2 and hit enter key

the code is an EVENT CODE. It should NOT be copied in a standard module
if you RIGHT CLICK the tab of SHEET2 and click VIEW CODE you see the code
as this is already in the vbeditor of the file you do not any thing except CHANGING the value in A1 of sheet2

the code is also repeated here for others

Please Login or Register  to view this content.