Hi Paul As you already know, you can't change the formula to relative when using icon sets. You will need to change them one by one. I would sug...
Can't read your binary file. Can you post in XLSX or XLSM instead?
Hi Hava Refer my answers in red. Hope this helps. Sunny
There is no attachment.
To further add, in such a situation, I would prefer to have all my data in a single worksheet and then use a Pivot Table to summarize them. No formula...
Hi chng.william168 and Frans Format is just one of the issue in the original file. The biggest problem is the value entered in the time columns (F ...
Glad to be able to help and Happy Chinese New Year. Sunny
It would be helpful if you can include an attachment of what you have and the expected results
Hi Tererai You can give this a try. The formula (in column E) is very long. Your sample contains non-printing character CHAR(160) and need to be re...
Hi Please give more sample data in an attachment. The example you gave is insufficient. Sunny
Hi Julian My codes are in Module 1 and Module 7 (I should have put them together). The others are not my codes and it came with the file. Sun...
Hi David Refer attachment Sunny
Hi David I have included the add new PO macro. For Q2 (calculate balance to be delivered), is it a separate report? Why are you including Previo...
Hi David Sorry I am still not too clear about your requirements. Hope I understood you correctly. Attached contains 2 macros that does the follo...
Excel always uses the underlying value for calculation, not the displayed value.