Target Value Macro
Solved
pitive35
Posted messages
81
Status
Member
-
Le Pingou Posted messages 12274 Registration date Status Contributor Last intervention -
Le Pingou Posted messages 12274 Registration date Status Contributor Last intervention -
Hello,
A few months ago, I was helped to create a macro for the goal seek function. The problem is that for professional needs, my spreadsheet has evolved and the macros no longer work.
This macro was based on the goal seek function:
On the main sheet PDC, we fill in the basic data and once the number is filled in C24 and the flow rate in column E24, the macro would start,
The macro operates on the calculation sheet, it fills my Lambda column (C24) with a 1, performs a goal seek on column H24, with the target value set to 0 and the cell to change is C24, and my cursor returns to sheet PDC in E24,
When I fill in row 25, I first enter the number in C25 and the flow rate in E25 and the macro starts on the calculation sheet on row 25 and so on.
Additionally, the macro included a function. If certain cells changed, the macro would restart automatically.
In my new spreadsheet, the cells are H13, P13, H15 and AN15 plus column AZ (from 24 to 53) and I would like to add a cell (V13).
Attached are my 2 spreadsheets:
The new one that doesn't work PdC_2015
https://www.cjoint.com/?3CyrRdrOgLq
The old one PDC_3
https://www.cjoint.com/?3CyrSjLAOmP
I know I was helped with this, but I really don't understand anything and as soon as it gets stuck, I don't know what to do.
Thank you very much in advance
A few months ago, I was helped to create a macro for the goal seek function. The problem is that for professional needs, my spreadsheet has evolved and the macros no longer work.
This macro was based on the goal seek function:
On the main sheet PDC, we fill in the basic data and once the number is filled in C24 and the flow rate in column E24, the macro would start,
The macro operates on the calculation sheet, it fills my Lambda column (C24) with a 1, performs a goal seek on column H24, with the target value set to 0 and the cell to change is C24, and my cursor returns to sheet PDC in E24,
When I fill in row 25, I first enter the number in C25 and the flow rate in E25 and the macro starts on the calculation sheet on row 25 and so on.
Additionally, the macro included a function. If certain cells changed, the macro would restart automatically.
In my new spreadsheet, the cells are H13, P13, H15 and AN15 plus column AZ (from 24 to 53) and I would like to add a cell (V13).
Attached are my 2 spreadsheets:
The new one that doesn't work PdC_2015
https://www.cjoint.com/?3CyrRdrOgLq
The old one PDC_3
https://www.cjoint.com/?3CyrSjLAOmP
I know I was helped with this, but I really don't understand anything and as soon as it gets stuck, I don't know what to do.
Thank you very much in advance
5 answers
-
Hello,
Sorry, but a file with protection and a password is out of the question...!
--
Best regards.
The Penguin -
-
Hello,
Well, it's not easy to research everything to understand, especially since the procedure from the old binder doesn't work (Runtime error 1004: Invalid reference) so it's not possible to go any further.
--
Regards.
The Penguin -
Hello,
I’ll let you check if it’s correct according to your request... !
Your file: https://www.cjoint.com/?3Czq5ioYGht
Note: it’s really a troublesome source when working with merged cells (keep that in mind for next time...)
--
Best regards.
The Penguin -
Hello,
PS: I know about merged cells, but for aesthetic reasons, it's more practical.
Well, the day you have problems with processing your data, you'll think twice about aesthetics.
--
Best regards.
The Penguin
