screenpower
New Member
- Joined
- Jan 13, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
This might be a bit complicated to explain but I will do my best. I created a tool to forecast what is needed to buy each month (U14:U25) based on Part # in cell B2. In short, every time I type a new Part # in cell B2, it automatically gives me my desired data (taken from other sheets) in order for me to manually input values in cells U14:U25. I would like to be able to save the entered values in cells U14:U25 for each individual Part # in a Sheet called "Saved" and bring them back and forth when changing cell B2 value.
For example in image 1, I entered manually "25000" in cell U17 and "7000" in cell U18 based on the data pulled from B2 being "ISO002total".
Then in Image 2, when I want to examine B2 = "EDR004total", my manually input U14:U25 stays the same as before, I then need to delete those values and enter new ones based on the data pulled from B2 being "EDR004total".
Now I think the solution for this is to store each manually input U14:U25 based on their respective Part # (B2) into another sheet called "Saved", see Image 3. And then once I switch between my Part # in B2, it automatically makes the connection with my data saved in my "Saved" sheet to fill U14:U25 based on what I last entered for that specific B2.
Let me know if this is possible please or if there are any other ways to do so. Thank you !
This might be a bit complicated to explain but I will do my best. I created a tool to forecast what is needed to buy each month (U14:U25) based on Part # in cell B2. In short, every time I type a new Part # in cell B2, it automatically gives me my desired data (taken from other sheets) in order for me to manually input values in cells U14:U25. I would like to be able to save the entered values in cells U14:U25 for each individual Part # in a Sheet called "Saved" and bring them back and forth when changing cell B2 value.
For example in image 1, I entered manually "25000" in cell U17 and "7000" in cell U18 based on the data pulled from B2 being "ISO002total".
Then in Image 2, when I want to examine B2 = "EDR004total", my manually input U14:U25 stays the same as before, I then need to delete those values and enter new ones based on the data pulled from B2 being "EDR004total".
Now I think the solution for this is to store each manually input U14:U25 based on their respective Part # (B2) into another sheet called "Saved", see Image 3. And then once I switch between my Part # in B2, it automatically makes the connection with my data saved in my "Saved" sheet to fill U14:U25 based on what I last entered for that specific B2.
Let me know if this is possible please or if there are any other ways to do so. Thank you !