Hello, I have a large group of cells that I need to change. The first cell of each row for table a needs to be changed to match with the first cell from table b. Unfortunately for each single row in table b, there is a variable number of rows in table a that need to be changed to match, so I can't just do a simple copy/paste. What I'm looking for is some way to automatically go through and change all of them, since there are far too many to do by hand.

I don't know anything about Access scripts/macros, but what I am thinking it needs to do is start with a pair of values, one that needs to be changed and one that it needs to change to, and then loop, increasing these numbers by 1 each time until it gets to a defined number.