Mirror last three rows on different and updating logsheet.

Hi guys,

I'm from Sweden and this is my first post. I'm pretty new to VBA but I'm completely sold. This is so much fun. I've set up a spreadsheet with a graphic dashboard and different sheets to each department of the company which our employees can use to send and report faulty forklifts with automatic email to repairmen. With every filed report/sent email, a hidden logsheet is constantly updated in column b c d e f g in a sheet called "Logg", information that shows a timestamp, user, truckID, type of error, "to be fixed"/"repaired" and department.
The thing is, i would like to mirror the last three or so rows on the sheet "Logg", or if possible only column b d and d. These three lines i want to show to everyone on the dashboard sheet, called "Start". I want the information showed on row 8, 9 and 10, J, K and L. If someone reports a new truck, Logg gets updated and the oldest of the three disappear on the dashboard. Is this even possible? I'v tried looking for an answer and I'm so grateful for all help I've found yet on this site.

Take care.

On your dashboard sheet, you can add the last three items with VBA. In the Logg sheet, you can setup a Worksheet_Change event to notice when a change is executed on the Logg sheet on the desired columns. You can then use the event trigger to write the last three items to the dashboard.

If you post a sample workbook as per the yellow banner above we can help further.

Ok. I'm not really sure what you need. I made a quick simple replica of my spreadsheet. The thing is, my dashboard is composed of shapes with charts. So cells will probably don't work? Is there another way to mimic the last rows on Logg to my dashboard?

Thank you!

Thank you. It works perfectly!