I'm new to VBA and am trying to replace a word found in L3 (AUCTION_DATE) with the value from H3 (Date Lot Sold - there are 70,000 entries and not all are 02-04-23) and then have this repeated throughout the worksheet for all items in Row L that have the words "AUCTION_DATE".
Basically replace the words "AUCTION_DATE" in each row of Column L with the value in the corresponding cell value in Column H (for each row).
Spent the best part of two hours trying to search for a site that had the solution, but none of the Find and Replace VBA codes would pull from another cell.
Any help greatly appreciated!!
Basically replace the words "AUCTION_DATE" in each row of Column L with the value in the corresponding cell value in Column H (for each row).
Spent the best part of two hours trying to search for a site that had the solution, but none of the Find and Replace VBA codes would pull from another cell.
Any help greatly appreciated!!