Forum Discussion
I found the limit of my Excel knowledge, can I ask for some help?
- I am closing this post, I guess was the wrong place, maybe not enough experts, not enough users or my post was unreadable; either way I found the solution by myself, so not the end of my Excel knowledge after all. Thank you for those who took the time to read it I guess.
Thank you for the reply, you are right. I am uploading the workbook now (apologies in advance for the style sheet, but I am dyslectic and the colours help me to quickly remind me the block of text on the tables and which columns have linked, calculated, output cells, etc.).
Anyway, I did unhide the columns to show the calculated cells on main sheet(tool) 'Wiz', Unfortunately due to time constraints I wasn't able to document/commented the workbook too much, but I am eager to start working on the issue, so I hope the sheet layout is fairly clear to understand.
Additional remarks:
I want to use the 'RESINV' sheet to validate if there is inventory and which 'slot' is on before allocating a pickface; hoping there is one available location closest to the reserve.
Thank you again.