I’m an industrial engineer, I tried to set up a program for this but it’s too complicated for me to achieve this work.
60% of work is done until now because I can run the program for one worksheet. But I cannot do it for the rest because other worksheets are not similar to the first one.
Every spare part in our stock is represented by one box into the Excel Data and localized like this:
30 D 002181
30 D : Area
21 : Location
8 : Level
1 : Position
We get into the meet of the project:
Project Goal: Create a basic program to clean up and do inventory automatically for every area.
I have 2 Data:
LiveData: Excel with one worksheet.
Every morning, I receive by email all spare parts that we have in stock (Real stock).
FixData: Excel with many worksheets (Every worksheet represents one stock area).
I tried to map all areas (one by one), so it’s ok.
I still have small problems (Areas don’t have same criteria).
• Number of sections per worksheet
• Sometimes section number is an even, sometimes it’s an odd and sometimes it’s both (It’s the case of the first worksheet).
• We don’t have same column number per section for every area.
So, what I’m wondering now to do is:
Do the same work that I did for 30&32 D for all areas.
And set up a menu to allow to the final user to choose one area and run the program automatically for this one.