Hello!i am trying to build an automated solution for stock for steel beams mainly. In the uploaded draft you will see what i ve done so far. my questions are : how can automatically results o3:s34 be transferred to h3:k34 of Stock Levels and then how can a summary be made without taking into consideration cells in red.
Bottomline is we need to start with an opening stock, make requisition, and then the leftovers, if any, be able to add them again as opening stock and deleting their initial value. And at the end be able to see sums per project and per section. Ultimately we can use a yearly file.
Obviously if sb has another solution i will be more than glad to see it!
Thank you and looking forward!
N
Hi Nikos,
I don't think this is something that should be handled with formulas only, you'll hit more and more road blocks ahead.
Best to use macros to control every step of the process.
I agree entirely, macros (VBA) is the only way to accomplish this.
BTW: please mention the Excel version you're using
Thank you. im not really familiar with vba so it will probably end here..you can see it as a long term project though, it ll be sth really unique online..!
Thnx all
Microsoft® Excel® for Microsoft 365 MSO (Version 2406 Build 16.0.17726.20078) 64-bit