S
sriram170
-----------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://forums.yourdomain.com.au/showthread.php?t=35307
-----------------------------------------------------------------------
Question: Is the queston meaning ful
- ye
- n
- o
- fai
-----------------------------------------------------------------------
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 i
the person has the data to fill only 10 rows and 10 columns that's not
problem but in that 10 rows he has to fill every cell, if he doesn'
then the macros should check while he saves or closes the sheet or wor
book and intimate him that each cell in that 10 rows and 10 columns ha
to be filled or else the workbook will not be saved.
In attached file if field Name, Age, gender, Address, Education
Occupations are filled and Experience is left blank.Now the Macro shoul
intimate him to fill the rows which he has filled only partially or som
of the fields. if he has not filled any fields its ok but if he fill
only certain fields in a row and left certain empty then it shoul
intimate.
And by the way kindly help me to design a macros which shoul
consolidate all the data which are entered by the user in the abov
workbook
+-------------------------------------------------------------------
|Filename: empty cell doubt.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=283
+-------------------------------------------------------------------
A poll associated with this post was created, to vote and see th
results, please visit http://forums.yourdomain.com.au/showthread.php?t=35307
-----------------------------------------------------------------------
Question: Is the queston meaning ful
- ye
- n
- o
- fai
-----------------------------------------------------------------------
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 i
the person has the data to fill only 10 rows and 10 columns that's not
problem but in that 10 rows he has to fill every cell, if he doesn'
then the macros should check while he saves or closes the sheet or wor
book and intimate him that each cell in that 10 rows and 10 columns ha
to be filled or else the workbook will not be saved.
In attached file if field Name, Age, gender, Address, Education
Occupations are filled and Experience is left blank.Now the Macro shoul
intimate him to fill the rows which he has filled only partially or som
of the fields. if he has not filled any fields its ok but if he fill
only certain fields in a row and left certain empty then it shoul
intimate.
And by the way kindly help me to design a macros which shoul
consolidate all the data which are entered by the user in the abov
workbook
+-------------------------------------------------------------------
|Filename: empty cell doubt.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=283
+-------------------------------------------------------------------