Recurring find a replace

**GOGOBE22** · 04-10-2023, 01:33 PM

Hi,
I have Excel 2016.
In each row, in cell B I have a name and then in cells C to I i have many different countif functions searching for that name in cell B on another spreadsheet. I have 50 rows with 50 different names and corresponding countif functions.
If i need to make a change to the countif functions range I need to copy the new sets of functions to all the rows and then one by one use "find and replace" to find the countif criteria (the name) and replace it with the correct name in cell B of the corresponding row.
I would like to automate this process, couldn't find a solution with chat GPT.
Any ideas please?

**TMS** · 04-10-2023, 01:51 PM

Are you still using 2010?

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

**alansidman** · 04-10-2023, 04:39 PM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...ml#post5813107