Telling Excel to drop down one row on another worksheet

[TitansFan]

I will try to do my best to explain what I am trying to accomplish.

First of all, I work for a construction company that specializes in the restoration of properties that have been damaged by fire and water. We have over 50 pieces of equipment (dehumidifiers, carpet fans, etc.) that we have to keep track of on a daily basis. I have created a workbook in Excel that consists of a summary worksheet and a worksheet per piece of equipment.

Here's what I'm wanting to do...

When a piece of equipment changes location, we want to enter that location in the Current Location cell of the summary sheet. I want this change to be reflected on the individual equipment sheet as well under it's heading of Current Location. Now, when we make another change in location on the summary sheet, I want to move 1 row down on the individual equipment's sheet so it, in essence, keeps a history of where every piece of equipment has gone.

I'm not well versed in VBA (I wish I was!) and hope this can be accomplished relatively easily. Hopefully I explained this well enough so someone can help me get started. I can be even more specific if I need to.

Thank you...

 

[TitansFan]

Let me give an example to help aid those who might want to attempt to help me.

Let's say we have a dehumidifier called D 10-1. Let's say we get a call that this dehumidfier needs to go to a location by the name of "Brookridge" to be used on a flood call. On our Summary worksheet, I have a column for Current Location. I would enter "Brookridge" next to D 10-1 in the Current Location column. I would want this same info (and other info) reflected on D 10-1's specific worksheet.

Okay, let's say after the equipment D 10-1 is used, we put it back into storage at a location we call "Preserve Garage". I would enter "Preserve Garage" in the Current Location column of my Summary worksheet. AT THIS POINT, I would want this new entry to be entered on a new row on D 10-1's specific worksheet. This way we have a running total or history of where each piece has been.

To solve this, I would assume that I need a loop to determine if a change has been made to a cell in the Current Location column of the Summary worksheet. After a change has been recognized, I need the loop to move down one row on the Equipment's specific worksheet and be ready for a new line of info to be entered.

I hope I haven't been too confusing!