I am a beginner in excel.
I have to update a master workbook monthly with new data from a temp workbook. The two workbooks have the same column heading. For now I have to find the blanks manually to fill row by row which is very time consuming.
How do I configure the excel to search for the blanks manually and fill the blanks automatically? Is there any function I can use? Or do I have to write the code manually?
Appreciate your help.
I have to update a master workbook monthly with new data from a temp workbook. The two workbooks have the same column heading. For now I have to find the blanks manually to fill row by row which is very time consuming.
How do I configure the excel to search for the blanks manually and fill the blanks automatically? Is there any function I can use? Or do I have to write the code manually?
Appreciate your help.