Help about an automation i want to create

damav78

New Member
Joined
Sep 29, 2024
Messages
48
Office Version
  1. 2021
Platform
  1. Windows
  2. MacOS
Hi, I would like your help in an issue that i cannot find a way to solve.
I have 2 cells.
The first one has a dropdown list with one option only available.
The second one is a formula cell that collects multiple data from other cells and its dynamic. It means that when i change values to other cells this cell is affected.
So what i would like to do is:
When the first cell is blank the values on second cell to change as normally do (dynamically).
If from the first cell i choose the predefined value from my dropdown list then the second cell to actually "lock" the current value that has at that moment and dosen't be affected anymore from any changes.
Thank you in advance
 
All works great for the first 3 rows of my testings where small quantities of 40000 and 50000 are (column A).
When I try to set a higher quantity at the last row and select "Fixed"... boom!!! column R has ######## with a value on the top -1,0371..... and column T has 0,0000.
Before I select "Fixed" the values as you can see from the previous photos was displaying normal.
 

Attachments

  • anydesk00006.png
    anydesk00006.png
    103.2 KB · Views: 0
  • anydesk00007_1.png
    anydesk00007_1.png
    110.3 KB · Views: 0
Upvote 0
So after that I did a quantity test and I figure out that any value I try to "Fixed" above 283000 return with error.
As you can see from this photo quantity 283000 was "Fixed" normally returning normal values.
 

Attachments

  • anydesk00008_1.png
    anydesk00008_1.png
    106 KB · Views: 1
Upvote 0
One thing I have to mention is that in order for my new formula to work I had to enable iterative calculations in excel.
I hope you have time to take a look... and thanks again for your help!!!
 
Last edited:
Upvote 0
Unfortunately, I am very busy with work and will not have time to have a look for the next two or three weeks. The other problem is that I can't work with pictures such as the ones you posted. You could use the XL2BB add-in (icon in the menu) to attach the desired selected ranges (not pictures) of your data. Better still, you could upload a copy of your file (de-sensitized if necessary) to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. I can't promise a solution, especially if you are using a Mac, but I will try to have a look as soon as I can spare some time.
 
Upvote 0
Unfortunately, I am very busy with work and will not have time to have a look for the next two or three weeks. The other problem is that I can't work with pictures such as the ones you posted. You could use the XL2BB add-in (icon in the menu) to attach the desired selected ranges (not pictures) of your data. Better still, you could upload a copy of your file (de-sensitized if necessary) to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. I can't promise a solution, especially if you are using a Mac, but I will try to have a look as soon as I can spare some time.
Dear @mumps i mainly use it in windows pc. The mac is my home computer.
Of course it’s not your obligation to help me… so when you have time and want to figure out what is going on I will be grateful.
I will post the file later so you can download it and test it.
Thank you in advance
 
Upvote 0

Forum statistics

Threads
1,226,842
Messages
6,193,293
Members
453,788
Latest member
drcharle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top