I need a macro solution to perform the following tasks...
1. Filter column A for all blanks
2. Select first resulting cell and enter a formula in it
3. Copy that formula into columns B thru O then down to last row in filtered list
4. Copy all new formula cells and paste value over them
1. Filter column A for all blanks
2. Select first resulting cell and enter a formula in it
3. Copy that formula into columns B thru O then down to last row in filtered list
4. Copy all new formula cells and paste value over them