F
Fable
Greetings,
I got in “sheet1” a database with theses headers “Name, Phone, Address
and below are the records rows 2-150.
In “sheet2” I have the a data entrée form (not VBA) its on the sheet
in cell A2 (Name), B2 (Phone), C2 (Address) and with three buttons a
the side Find, Delete, Add. Cell A3:C3 is the "Results Area"
I would like the "Find" button return a search from "Sheet1" for any o
the 3 Headers and display the result in Cell A3:C3. The "Delete" butto
should the delete the result in "sheet2" cell A3:C3 and the entire ro
/ record from the database in "sheet1" and the Add button would add
record to the result area A3:C3 and to the database in "sheet1".
I know Excel has the Data Form and J-walk have a version 2 of this, bu
Im looking for VBA code it self that make this happen.
Thanking you in advance
I got in “sheet1” a database with theses headers “Name, Phone, Address
and below are the records rows 2-150.
In “sheet2” I have the a data entrée form (not VBA) its on the sheet
in cell A2 (Name), B2 (Phone), C2 (Address) and with three buttons a
the side Find, Delete, Add. Cell A3:C3 is the "Results Area"
I would like the "Find" button return a search from "Sheet1" for any o
the 3 Headers and display the result in Cell A3:C3. The "Delete" butto
should the delete the result in "sheet2" cell A3:C3 and the entire ro
/ record from the database in "sheet1" and the Add button would add
record to the result area A3:C3 and to the database in "sheet1".
I know Excel has the Data Form and J-walk have a version 2 of this, bu
Im looking for VBA code it self that make this happen.
Thanking you in advance