I am wanting to goal seek in one "set cell" by changing the values in multiple cells. For example, A1:H1 are my range of cells with formulas that I want to change and J1 (with a formula) is my set cell that I am wanting to goal seek.

Two additional requirements are that there can be no duplicate values in the range A1:H1 and that the goal value will sometimes change, so I would like to reference the goal value from a another cell, say cell L1.

I am just starting to learn how to use VBA codes created by other people and have tried to modify a couple of codes I have found that do similar functions, but have had no luck in making them work. I am hoping this is not an overly complicated code to create. Any help would be greatly appreciated.