VBA formula using a loop


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!

Taidot: Excel, Visual Basic

Näytä lisää: word document using vba line formatting, vba loop using multiple conditions, paste formula vba excel, accessing web pages using excel vba https, rank formula vba, excel using custom vba script, using vbscript vba macro add user, connect access using excel vba, calculate salary using excel vba, projects using excel vba, accessing web pages using excel vba, web scraping using excel vba, access ftp using excel vba, data oracle batch using excel vba, download web page using excel vba, generate report word using excel vba

Tietoa työnantajasta:
( 8 arvostelua ) Sydney, Australia

Projektin tunnus: #13172819

Myönnetty käyttäjälle:


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

$25 AUD 1 päivässä
(23 Arvostelua)

Hi there, I have a vast experience in Excel and VBA and would be happy to help you on the project. Best regards, Eugene PS. Windows only

$25 AUD 0 päivässä
(209 Arvostelua)

7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$50 AUD 2 päivässä
(188 arvostelua)

Hello, I am ready to write the VBA code to multiply a number of cells. Highly experienced in Excel Programming, Excel automation and Macros. I am good at Visual Basic and .net for Applications (vba) inside out; writ Lisää

$150 AUD 3 päivässä
(115 arvostelua)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 AUD 1 päivässä
(124 arvostelua)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind o Lisää

$50 AUD 1 päivässä
(110 arvostelua)

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets and Getting target result. I think your pro Lisää

$30 AUD 1 päivässä
(47 arvostelua)