Hello all! This is my first time posting so please forgive the lack of detail. . .
I am trying to create a table with a summary of items that need to be Restocked across 4 different sheets. I am relatively new to Excel and while I've been able to puzzle other issues out thanks to the help I've found on this site, this one has me at a loss.
Essentially, I want the Summary to look accross the 4 sheets to find items labeled "Restock" or "On Order" and transfer over the Nomenclature, Part No., Qty needed (Authorized - On Hand), and its status (Restock or On Order). I am on a very restricted network and cannot directly attach images or files to this post but I can send a sample if requested.
Thank you all in advance!
I am trying to create a table with a summary of items that need to be Restocked across 4 different sheets. I am relatively new to Excel and while I've been able to puzzle other issues out thanks to the help I've found on this site, this one has me at a loss.
Essentially, I want the Summary to look accross the 4 sheets to find items labeled "Restock" or "On Order" and transfer over the Nomenclature, Part No., Qty needed (Authorized - On Hand), and its status (Restock or On Order). I am on a very restricted network and cannot directly attach images or files to this post but I can send a sample if requested.
Thank you all in advance!
