Log In
Register
Home
Active Member
December 11, 2023
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
Trusted Members
October 17, 2018
Offline
I agree entirely, macros (VBA) is the only way to accomplish this.
BTW: please mention the Excel version you're using
Active Member
December 11, 2023
Offline
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
1 Guest(s)
