Search results

I have made a certificate in Word which takes values from Excel database. Now there is a column which gives me percentage. I want only 2 place after decimal and I did this in Excel using "decrease decimal" button. But when Word fetches these values by mail merge, it gives several places after...

Yes this one's good. But I want only the list of names that are approved or conditionally approved.

Hi Faseeh, I hav named the sheets on supplier's name. It can be Sheet1, Sheet2 and so on as an example...

Hi, I have made an excel file which contains a different supplier's information on each sheet, along with one of the categories approved, conditionally approved, conditionally rejected and rejected. Now I want one summary sheet to display a list of all the suppliers that are either approved or...

Hi Debraj, your script executes beautifully and I am happy with it. But it doesn't give me the option to continue saving if i have intentionally left the cells blank. Pls help.

It works but with some error... The cell I setup shows true when nothing or contract or out-of-warranty is selected in drop-down and false when under-warranty is selected but nothing is entered in other two columns. So good so far. But I added the above script in VBA and changed the name of...

Hi, I am making a sheet where there are 3 columns. Column A has 3 list items Contract, Under-warranty and Out-of-Waranty. Column B is for warranty certificate no. and Column C for expiry date of warranty. If a person selects "Under-warranty" in A2 from the list, but does not enter a...