Hey yall,
Im stuck in a rut (thought) right now and i really need to get on a different path.
Situation/Objective: I need to validate two cells on one worksheet, and if true then i need to find the cells data on another worksheet(same row), & copy/paste that entire row(or 'add' the other 8 columns of data) back where the cell data came from. Currently im in a For Loop for each row of data, but then entering an index.match into each cell to pull the data... i know this isnt the right way, and im having trouble with the "Column & i" reference in them.
i guess i just need to loop a Range.Find using multiple variables. ?? Someone told me this, but i dont know if it works in what im trying to do.
Anyway, im hoping someone has "the" answer, instead of my makeshift ways of arriving at a location. Thank you in advance!
Bookmarks