Käynnissä

VBA formula using a loop

Hi,

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ää: paste formula vba excel, rank formula vba, projects using excel vba

About the Employer:
( 8 reviews ) Sydney, Australia

Projektin tunnus: #13172819

Myönnetty käyttäjälle:

urmate

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)
4.0
watersev

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)
6.2

7 freelanceria on tarjonnut keskimäärin 51 $ tähän työhön

deepbluetech

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)
7.1
Webxpert4u

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)
6.9
P0L

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)
6.4
schoudhary1553

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)
6.1
vsprybhanu

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)
4.9