Hi Guys,
I tried to modify the excel file has been published by VijianSale-Database-V4.1.1-Ask.xlsm which use excel as database and can easy to filter information of Data sheet on view sheet using Update drop down then search something in box and click on show data to get the result.
I got issue when the data in columns named PO, Quotation, VAT invoice are merged as below:
Merged Cell.png
When i click Update drop down on View sheet then the error Type mismatch will appear. I know that now the function of Show Data cannot get the Cells that not have data. Could someone help me to change the code to permit show data can work even the cells have been merged ?