We use some really old software on our AS400. I have recently begun importing some data into Excel from these cumbersome databases on our software. The problem I’ve run into is a Y2K workaround. I have to use string functions to turn the AS400 date into a useable Excel date. That’s not a big problem. The problem is that I want to use that formula on every date in the list – which changes length with each download. However, I do not want to have to copy and paste each time.
So, here’s thequestion: Is there any VBA code or some Excel feature I can use to place this formula into each cell in my list without copying the formula to the entire column or dragging the formula to the bottom of the list? Automation is the name of the game here.