I need advice as to how I can create a data entry worksheet in Excel and have it transform into a table in a separate worksheet. This is used for tracking the location of items shipped to different locations.
Sample Data - this is the page for data entry
Based on the data, plot into a table like this for easier reference
Once an item is taken back, the information is deleted and the shipping process continues. Not sure if this can be done in Excel but am just exploring possibilities.