Hello there.
Please does anyone have an idea on how to Search for a record by number, eg 442. And replace it with another more upto date record (from another sheet) by copying the new data over the existing row, rather than adding it onto the bottom.
If anyone knows a macro to do this, i would be very grateful
Many thankx in advance!
Mark