Recent content by sdey73

hi kutty, i am not sure about what you are looking for, but i think the following link file will help you. download the file, open it, right click on any cell and choose "insert date". https://www.dropbox.com/s/o61men4r4jf48ip/Calendar.xls regards sudipta

K.Govardhan how would you like to get your data if you filter multiple name of pan number? regards sudipta

salviakshay can you upload the sample file through dropbox? because your logical formula related to 'if' is not clear. regards sudipta

salviakshay i think your formula is not complete, you have missed the 'value_if_false' in 'if' formula. regards sudipta

dear Muhammad Shakeel except macro why don't you use a formula, go through the link below may be it help you... https://www.dropbox.com/s/e621b5vzywy4501/Macro%20for%20Vlook%20Up.xlsx regards sudipta

@webmax thanks a lot, but don't use the word kindly, after all we all are the friends @Debraj Roy thank you for your support thanks to both of you regards sudipta

hi hui, thanks again for your help, but need one more help on this topic, can't we get the "SR.NO" serialy except "x" on sheet2? https://www.dropbox.com/s/vzg8blh73qsvugw/COPY%20TEXT.xlsm regards sudipta

thank you hui regards sudipta

hi friends, need your help, what i want is in sheet1 only one row is there where user will fill, and end of the row a command button is there which is clicked by the user after complete the details at that row. when the user will press that button the entire data of the row will be copied to...

dear all, i just wants to know is there any way to insert multiple number of rows or columns in a worksheet? say in a report i wants to insert 115 number of rows after a302, or wants to insert 9 columns after column "J", how to do that at a time? one way to do that is after selecting 9 columns...

@nazmul_muneer are you from vodafone??????? regards

@SirJB7 sorry to say but i think a little mistake done by you... your formula is '=B$6*IF(MOD(COLUMN(B$6)-1,$B$1),1+$B$2,1)' where u have missed "=0" the formula must be "=B$6*IF(MOD(COLUMN(B$6)-1,$B$1)=0,1+$B$2,1)" may be i am wrong, if so then sorry.. regards sdey73

hi debraj, thanks for your reply and for suggested links. regards sdey73

@Debraj Roy realy you are genius, thank you very much, the given formula solve my problem, just one help more, wants to know the function of 'mod' or any link i can found it. regards sdey73

sorry, please go through the following link.. https://www.dropbox.com/s/kmiay7lxqvgd1to/rent%20change.xlsx regards sdey73