.
I've removed the tables for you.
I noticed on some sheets, you have duplicated the data in approx rows 2 - 20 by repeating the same in rows below. Keep in mind, anything you enter in Column G, regardless of row location,
will be transferred to the RESTOCK sheet. If you are duplicating the data from the top rows to rows below ... your Restock numbers will be skewed.
Also note that manual input of data on the Restock sheet should not be done. A notice is placed on the Restock sheet as a reminder.
The macro also requires Column A on all sheets (except Restock sheet) to have an ITEM ID number. If there is a chance an entry may not have an ITEM ID number, we need to
edit the code.
Bookmarks