We have been using Excel for the past 5 years to create a file(part number) under a customer's name (folder)
so on our NAS we have a folder called "customer drawings" in that folder we have MULTIPLE customer folders (under each customer's name) then a or multiple excel file (part number and rev) this file then has multiple tabs (Main menu,Sales Request, Costing sheet , BOM, Cut sheet, Drawing, Production, Quality control and Shipping) each of these tabs has different data in it and some are "locked" with a password...
DREAM would be to be able to pull all this data out and get it into a database type version of even pull it out and put onto a tab/sheet so we can import it into our new ERP system
at minimum is to get the Costing sheet, BOM and cut sheet info extracted.
I can send a sample file if it helps.
so on our NAS we have a folder called "customer drawings" in that folder we have MULTIPLE customer folders (under each customer's name) then a or multiple excel file (part number and rev) this file then has multiple tabs (Main menu,Sales Request, Costing sheet , BOM, Cut sheet, Drawing, Production, Quality control and Shipping) each of these tabs has different data in it and some are "locked" with a password...
DREAM would be to be able to pull all this data out and get it into a database type version of even pull it out and put onto a tab/sheet so we can import it into our new ERP system
at minimum is to get the Costing sheet, BOM and cut sheet info extracted.
I can send a sample file if it helps.