Hi,
I have 12 digit ID number in column A in which 7th digit of no. is scheme code for number start from other than 9 and 5th digit is scheme code in number start from 9.
Pls note that ID number is in the txt format as it's downloading from other system.i have tried to convert in to number...
Hi,
I have around 25 sheets in the workbook. inpute data start in every sheet from A7 but there is some sheet wherein no data. i want to print all sheet only if there is data in A7
currently i am clg+select sheet with data available and then print.
is there any solution thru macro which by...
Hi,
I want to make Date entry form in excel to inpute data in two field. ( chq no ) and ( amt. ) after entering the number in chq no filds and enter cursor shuold go to amt field and again after enter cursor shuold be on chq no field. without using any tab or arrow key.
date should save in...
I have hug data of name in column A with first name, middile name, surname format and in column B same name but diffrent format like surname , first name and then middle name
i want any formula or macro or to highlite both cell with match name.
current have tried =exact formula but many...