I need someone to write the VBA code to multiply a number of cells. I have 3 sheets in Excel, and I have attached a file with a number of examples and solution notes. In Sheet1 I have a data set, and I need a calculation in Column E (named ‘Charge’). In Sheet2 I have a table of Items and Products, with the Amount % for each, and in Sheet3 I have the Amount for each Item and Product, for each effective date. I only need the calculation to be performed if the Description in Sheeet1 is “Monthly Amount” and the Product is the same as the cell below. For example, if the cell below is a “Monthly Fee” but it has a different product then no calculation is performed. If the line item is a Monthly fee, and Amount should be taken from Sheet3 and multiplied by the % Amount in Sheet2. Please note the Item and Product needs to match in Sheet1, Sheet2 and Sheet3 – these criteria need to match in all three sheets. Finally, the Amount value in Sheet3 changes each year, so the Amount input in the calculation Sheet1 needs to occur on or after the date in Sheet3,
Thank you so much for your help!
HI Contact me for an efficient, perfect, well documented development of your project according to 100% accuracy and requirements, with dedicated support. Thanks Farah Saif
7 freelancers are bidding on average $51 for this job
Hi, I am an Excel VBA expert and can handle the requirements. I shall provide a 'Update' button on Sheet 1 to initiate the calculations based on the laid down rules. Please confirm. Regards, Arul