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 at
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 of
the 3 Headers and display the result in Cell A3:C3. The "Delete" button
should the delete the result in "sheet2" cell A3:C3 and the entire row
/ record from the database in "sheet1" and the Add button would add a
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, but
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 at
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 of
the 3 Headers and display the result in Cell A3:C3. The "Delete" button
should the delete the result in "sheet2" cell A3:C3 and the entire row
/ record from the database in "sheet1" and the Add button would add a
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, but
Im looking for VBA code it self that make this happen.
Thanking you in advance,