This Experts Exchange lesson shows how to use VBA to loop through rows in Excel. In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values where it is blank can be run.
This lesson shows the manual process to fill blanks, and the VBA code to implement it.
This is Part 2 in a 3-part series to discuss error handling in Excel.
Part 3 of this series will add errors to the code and then show how to fix them. Part 1 of this Experts Exchange series suggested basic error handling code.