Unanswered: How to change multiple Cell Values based on another cell value
I see a bunch of these thread but going through all of them none of them helped....
So I justed opened up my own thread
I am new and I wanted some help with one some excel problem i have
So the question is that i need a VBA or macro that can change multiple cell based on another cell value so some value can be replaced by the new table
so pretty much i want the column to match (find corresponding sku)with the headers and replace the cell value with (new search term) so old values will be in search terms and i want to be to replaced with the first table? also i dont need table 1 to run against table 2 and table 3 at the same time i can manually run it multiple times myself. Also i need it to only replace the value with the corresponding cells.... and if it doesn't have a match just leave the cell value alone if it doesn't have a replacement terms.