VBA Solver Macro not working

[Bruno Silva]

Hi.
I have adapted a VBA macro I looked up in microsoft excel support site, but it doesn´t seem to work exactly how I wanted to.
This macro is using the Solver to calculate a value for each row of information I have.
I have set up an example of 3 rows where i want it to calculate the values in cells F2:F4. But it seems to be calculating only for cell F2
I have an attached file with the example
Can anyone help?

[shg]

There's no code in your file.

Row\Col	C	D	E	F	G	H	I	J	K	L
1	PVP Antes	Qtd Antes	Novo PVP	QTD Simulada	E1	Vendas Atuais	Vendas Simuladas	Delta Vendas	E2
2	2	20	3	18	-0.20	40.00 €	54.00 €	26%	-0.2
3	2	20	4	14	-0.30	40.00 €	56.00 €	29%	-0.3
4	2	20	5	11	-0.30	40.00 €	55.00 €	27%	-0.3
5
6									0.000	K6: =SQRT(SUMXMY2(G2:G4, K2:K4))
7
8										Set K6 to Min by changing F2:F4

[Bruno Silva]

Wrong file...sorry.
I have attached a new one. Hope it's ok now.
Thanks

[shg]

Why don't you try what I posted first? Your Solver model was completely hosed.

[Bruno Silva]

I don't really know if I understood your solution.
I have set K6 to what you proposed, but I don't know what to do next.
What I want is the values in F2:F4 to be set automatically

[shg]

Data > Solver,

Set Objective: K6

To: Min

By Changing Variable Cells: F2:F4

Subject to the Constraints (none; delete all those you have)

Then press Solve; does that give the desired results?


It's useful to know how to use Solver from the user interface before trying to automate it, no?

[Bruno Silva]

Thank you very much.
This gives me the desired results.

I really do appreciate the time you took to help me!

[shg]

Good job, you're welcome.