Thread: assistance with cleaning up an item inventory workbook

I basically am posting this because I am brainstormed out. At my workplace, I am responsible for tracking different items that are used in a specific type of maintenance. What is mainly determined in my area is the condition of the item and where it is sent from here (whether it is sent to be repaired, trashed, or back into the serviceable items inventory). My area is mainly just a pass through for the items to make sure they are going to the correct place. I currently am using an excel workbook to track what items are processed in this "turn-in" room I work in, on what shifts, and on what day. I also have a month list that all items from each day are put on to in order to make sorting and finding certain items easier. The format I am using now (one sheet of the workbook for each day of the month, a dividing line after each shift on these individual sheets, and the last sheet of the workbook serves as the running month list) cannot be the easiest way. I have tried to format a workbook that was almost completely automated, because this is what cuts down on human errors of data entry, but I do not really have the knowledge or experience in excel needed to go as in depth as this looks like its going to call for.

I know this may be very confusing, but if you feel like you can help just email me for greater detail.


I can also show you an example of what I'm working with now if you email or message me.
ANY HELP IS APPRECIATED!!!!

Welcome to the forum, jacglc.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

You'll want to condense all the data to one sheet, with a header row at the top and a column for each relevant field, and no blank rows. Then someone can help from there.

Amend your Thread Title and read the rest of the Forum Rules