kabbak
01-18-2012, 07:06 AM
Thanx Pros for the excellent help all the time.
I do have a table of data (on Worksheet 1) that i can search from another worksheet (Worksheet 1) Thanx to mdmackillop for the code (http://www.vbaexpress.com/forum/showthread.php?t=40420).
I'd now like to be able to make corrections on a searched entry on sheet 1 so that running some code would re-insert the corrected entry back into the table.
Column A has numbers which am not going to be correcting whatsoever so i was thinking of a code that would search the table by column A and on finding the entry, paste the corrected entry over it. (in that same row).
Hope am not diverting your minds from a possible cheap solution to the problem.
The Columns of Data are from A to R and corrections are going to be made on column E or H or both.
I do have a table of data (on Worksheet 1) that i can search from another worksheet (Worksheet 1) Thanx to mdmackillop for the code (http://www.vbaexpress.com/forum/showthread.php?t=40420).
I'd now like to be able to make corrections on a searched entry on sheet 1 so that running some code would re-insert the corrected entry back into the table.
Column A has numbers which am not going to be correcting whatsoever so i was thinking of a code that would search the table by column A and on finding the entry, paste the corrected entry over it. (in that same row).
Hope am not diverting your minds from a possible cheap solution to the problem.
The Columns of Data are from A to R and corrections are going to be made on column E or H or both.