Hi
I just face a problem in counting numbers if any row is added/deleted in between. I am new to VBA macro and dont have much experience in solving problems.
Here, in the export sheet i have looked up sales values on the baseline sheet according to the supplier numbers and i need to count the number of suppliers based on the current price status of vendors in the calculation sheet and their corresponding revenue. I have three categories All vendors, Top 550 and Top 550 Interco No and the count of vendors/sales should be displayed in the calculation table 1. The problem here is , if any new status is added the additional rows has to be added in the table range and if any status is not present/deleted means the corresponding row must be deleted and other upcoming rows has to be replaced instead of the deleted status.
I have highlighted Top 550 and Top 550 Interco No in different colors and the values are reflected in the Export sheet. The corresponding total has to be added in the Total row.
The below table must be automatically filled based on the count of vendors across the vendor status with the sales from the Table 1.
For example, under No supplier response category, i have 6 vendor status, so the sum of all the vendor counts with the corresponding sales value for all vendors, top 550 and top 550 no interco has to be filled.
Similarly, from the Export- E sheet, the values are looked up from the Revenue-E sheet and the count of vendors/sales value has to be pulled from the Export-E sheet to the Calculation-E sheet.
Please help me with the solution for the countif problem. Have attached the sample file for reference.
Thanks in advance!
I just face a problem in counting numbers if any row is added/deleted in between. I am new to VBA macro and dont have much experience in solving problems.
Here, in the export sheet i have looked up sales values on the baseline sheet according to the supplier numbers and i need to count the number of suppliers based on the current price status of vendors in the calculation sheet and their corresponding revenue. I have three categories All vendors, Top 550 and Top 550 Interco No and the count of vendors/sales should be displayed in the calculation table 1. The problem here is , if any new status is added the additional rows has to be added in the table range and if any status is not present/deleted means the corresponding row must be deleted and other upcoming rows has to be replaced instead of the deleted status.
I have highlighted Top 550 and Top 550 Interco No in different colors and the values are reflected in the Export sheet. The corresponding total has to be added in the Total row.
The below table must be automatically filled based on the count of vendors across the vendor status with the sales from the Table 1.
For example, under No supplier response category, i have 6 vendor status, so the sum of all the vendor counts with the corresponding sales value for all vendors, top 550 and top 550 no interco has to be filled.
Similarly, from the Export- E sheet, the values are looked up from the Revenue-E sheet and the count of vendors/sales value has to be pulled from the Export-E sheet to the Calculation-E sheet.
Please help me with the solution for the countif problem. Have attached the sample file for reference.
Thanks in advance!