Hello everybody,
I need to gather data from different sheets.
I receive materials that can be categorized by thickness (2, 2 1/4, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) we receive a load of mix materials with different thickness from time to time. I have to prepare a sheet containing the receiving order then pull different info such as thickness, length and width and a serial number from these orders (sheets) and update a main sheet that sort of shows my inventory of this material. And whenever I use any of these material, it automatically deducted from my inventory.
I really appreciate it if anyone can help me here.
Bookmarks