Forum Discussion
I could use help trying to replace data in the same cell.
Hi, I looked online and tried substitute but that didn't give me anything I could copy/paste in a field. I tried replace but the macro wouldn't work because I couldn't setup the index. I have mu...
The issue is I have 670+ cells I have to do this on. I will have additional data pulls incoming. I was looking to see if I could speed it up. Sheet 2 has no real bearing on the task but it is what I use to find duplicate names through multiple requests. It saves the time of repeatedly looking up NTIDs.
I don't even know if I understand what "this" is. You have in the example
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
But I assumed that was indicative of many different individuals with different last names, first name and job titles and that on sheet2 was the same thing that there is a list of each name and replacement value. but now I don't know, is it the same name repeated?
As for the 670+ cells, fine, you have a formula that does what you need and you put those 670+ in cells A1:A670 and the formula in B1:B670 (or use dynamic arrays to apply the 1 formula to the whole set)
but like I said, it is hard to help if I don't understand what you need.
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
LastName, FirstName, jobTitle
But I assumed that was indicative of many different individuals with different last names, first name and job titles and that on sheet2 was the same thing that there is a list of each name and replacement value. but now I don't know, is it the same name repeated?
As for the 670+ cells, fine, you have a formula that does what you need and you put those 670+ in cells A1:A670 and the formula in B1:B670 (or use dynamic arrays to apply the 1 formula to the whole set)
but like I said, it is hard to help if I don't understand what you need.