Hey everyone!

I originally received help a long time ago here when I had a project!

Working on that same project, buy my experience in excel has grown some and I've learned a little VBA and want to improve the formula I've been relying on to keep my status board updated in excel.

The formula looks at the A/C Tail number. For Example in Cell D2, the formula is looking at A/C 92 in Cell B2, and Engine Position 1 (AL5), then looks on the Data sheet, to see what line that matches to and returns the row number. With the row number I can use index to get the letter code related to that engine and aircraft.

The problem with this formula is i constantly have to update the ranges for how many rows it scans over for data. As we receive more samples and the data page starts to become larger the computer cannot handle a unlimited range of scanning the rows each time.

My goal is to start VBA code that updates when the workbook is saved. I barley understand how this formula works so I was hoping to get some help with the VBA code, at the very least pointed in the direction I need to work towards