I have created a table of names - Last, First, Address, Phone #, etc - in one sheet in my file. This is my "table page"
On another sheet I have created an area to input these names. This is my "input page". I then wrote a macro that will copy this information to the other sheet where the table is, append the table with this new information at the bottom, and then sort the list in ascending order. That is very simple and works fine.
I would now like to be able to search this table by inputting a value/text in the Last Name field of the input page and have the information populate the rest of the input fields.
I would also like to create "NEXT" and "PREVIOUS" buttons so I can retrieve data one at a time and have it in the input fields.
Lastly, If I notice an error in the input, I would like to correct it and then have this data replace the bad data in the table.
I have looked at various methods using lookup, vlookup, index, offset, and match. While I have had some success, I cannot complete aeverything I need mostly due to the table having the same information (Last Name).
Any help anyone can give will be appreciated.
On another sheet I have created an area to input these names. This is my "input page". I then wrote a macro that will copy this information to the other sheet where the table is, append the table with this new information at the bottom, and then sort the list in ascending order. That is very simple and works fine.
I would now like to be able to search this table by inputting a value/text in the Last Name field of the input page and have the information populate the rest of the input fields.
I would also like to create "NEXT" and "PREVIOUS" buttons so I can retrieve data one at a time and have it in the input fields.
Lastly, If I notice an error in the input, I would like to correct it and then have this data replace the bad data in the table.
I have looked at various methods using lookup, vlookup, index, offset, and match. While I have had some success, I cannot complete aeverything I need mostly due to the table having the same information (Last Name).
Any help anyone can give will be appreciated.