Source

propellhatt

u/propellhatt

r/vba•

Use of VBA to automate purging of older entries in a column in Excel, adding new empty cell automatically after data entry.

Unsolved

Hi. I first posted this over at the fine folks of r/excel , the first suggestion I got was to try over here. I've had a sneaking feeling I'd have to resort to VBA to get this working, but there I'm even more clueless than in Excel, so I'm really hoping you guys could help me here.

I work in the tower of a small, Norwgian airport and we need to create a spreadsheet that helps us keep track of our currency, with regards to shifts worked and training completed. Excel is not my primary, or secondary competency, or something I dive deep into often, if at all, but now I need help with some (to me at least) advanced stuff.

I have a column, B, where I input dates

53
r/excel•

How can I automatically purge older entries in a column, and use an IF function to check one date against multiple others?

unsolved

I work in the tower of a small, Norwgian airport and we need to create a spreadsheet that helps us keep track of our currency, with regards to shifts worked and training completed. Excel is not my primary, or secondary competency, or something I dive deep into often, if at all, but now I need help with some (to me at least) advanced stuff.

I have a column, B, where I input dates, these representing shifts worked. I have a cell, currently E21 where I sho the date where a person will no longer be certified to work if absent until that date, but will then require supplimentary training. The requirements is 20 or more shifts during the last 3 months. Exceptions are if the person was certified f

13