Thank you for the video. Is very helpful. I have a question to see if you can help. I have a supplier that I will going to used a Blanket PO. I did the PO for a total of $1.4 million and I enter the amount as a quantity with a value of $1.00. When I receive the invoice I will receive the total amount of the invoice again the Blanket PO. How can I do the rounder for the good receipt and how to create a log file?
Hi, glad I could help. Do you mean creating a new sheet from where you will have an automated ready made format for a receipt? When you say log file do you mean a user log file that will be created every time someone uses the excel?
You might need to check on the Conditional Formatting > Manage Rules and check the formula range. It may have distorted the rule if you just created it. Minsan si Excel can can sometimes distort the rules that you have just created. Hope this helps.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/n.gif)
Thank you for the video. Is very helpful. I have a question to see if you can help. I have a supplier that I will going to used a Blanket PO. I did the PO for a total of $1.4 million and I enter the amount as a quantity with a value of $1.00. When I receive the invoice I will receive the total amount of the invoice again the Blanket PO. How can I do the rounder for the good receipt and how to create a log file?
Hi, glad I could help. Do you mean creating a new sheet from where you will have an automated ready made format for a receipt? When you say log file do you mean a user log file that will be created every time someone uses the excel?
bakit po kaya nag eerror po sa akin yung Conditional Formatting? excel thinks its a formula daw
You might need to check on the Conditional Formatting > Manage Rules and check the formula range. It may have distorted the rule if you just created it. Minsan si Excel can can sometimes distort the rules that you have just created. Hope this helps.
@@rodrigobonzerrlopez6766 thanks for this!