Dear friends,
i need a macro which should check whether all cells are filled in a row, let me say if there are 21 rows and 21 columns in a excel sheet and if the person has the data to fill only 10 rows and 10 columns that's not a problem but in that 10 rows he has to fill every cell, if he doesn't then the macros should check while he saves or closes the sheet or work book and intimate him that each cell in that 10 rows and 10 columns has to be filled or else the workbook will not be saved.
And by the way kindly help me to design a macros which should consolidate all the data which are entered by the user in the above workbook.
Bookmarks