In Progress

Build a VB macro for excel that: [login to view URL] in MS Excel task bar b. provides a user input panel for simple repetitive math operation

I work with spread sheets every day as part of what I do I deal with items lists that include: a. quantity, b. price, and c. total quantity x price. More often than not I get spreadsheets where the price (each) given is actually the sum price. I basically need a macro that will perform a simple division and field cut and paste in 3 fields. The problem is that these 3 fields may be in different locations in different templates when I receive them. What I have to do is take the total value, divide by the quantity, and take that value and paste into the price each field.

TAKE "TOTAL"; (STORE VALUE); DIVIDE by "QUANTITY"; PASTE product in PRICE EACH field; then PASTE TOTAL in correct field. THEN goto next row and replicate forever until STOP button, or encounter empty QUANTITY field

I need to automate across an entire worksheet using a macro button, that when run:

a. identify/ask sum price row/column

b. identify/ask price each row/column

c. identify/ask total price row/column

//this is done only once and stays in play unless the "reset rows & columns button is pressed

a. take sum price

b. divide by quantity

c. insert into price each field

d. insert total price into total price field

- an undo button would be a plus.

So macro operations are:

a. main Run button - runs from tool bar or somewhere always available - opens pop-up window with 3 sets of 2 boxes for:

- enter "QUANTITY" row:_____ column ______

- enter "PRICE EACH" row_____ column______

- enter "TOTAL" row______ column_____

b. EXECUTE button performs the action of:

<for each subsequent row until STOP or empty field>

- take total price value <store it>

- divide by QUANTITY

- write to PRICE EACH field

- write TOTAL back to TOTAL fields

I would like to be able to test/validate, and provide feedback for a second "tweaking". 50% milestone on start, 50% on completion.

Skills: Excel, Visual Basic

See more: repetitive input user, admin panel demo user, software write mq4, software write chip epson, useful software write book, opertor operation math, software write web specs, prompt integers input user reverse order, excel macro simple input output, create access database input user form, free software write user guide, software write edid, simple xml operation, free software write company profile, squid cache multiple user simple project, mips assembler input user, software write websites idea, excel macro user input drop menu, software write book images, matrix program java input user

About the Employer:
( 1 review ) Tacoma, United States

Project ID: #11818746

Awarded to:


-Went through the excel and the description. -Will get the input parameter on click of the button, the macro will do the calculations and fill in the template. -Can get the total sum divided by quantity and arrive at More

$80 USD in 3 days
(21 Reviews)

14 freelancers are bidding on average $104 for this job


$200 USD in 3 days
(104 Reviews)

Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before More

$88 USD in 3 days
(69 Reviews)
$111 USD in 3 days
(51 Reviews)

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$99 USD in 3 days
(41 Reviews)

Hi, i can do this for you, it will be an VBA code with forms :) .

$150 USD in 1 day
(13 Reviews)

Hello Sir, How are you? I have read the project and understand your requirement. I am a highly trained on Data Entry ,Web search, Web scraping Expert with great knowledge of Excel. I definitely have some questio More

$55 USD in 2 days
(27 Reviews)
$277 USD in 3 days
(6 Reviews)

Hi Friend, I have total 6+ years of experience in excel reporting and VBA Macro. I have experience in all MS office products including SharePoint. I have written Macro for different type of works/ projects. More

$35 USD in 2 days
(22 Reviews)
$111 USD in 3 days
(1 Review)

Hello! Here are several question I'd like you to address to better assess the task ahead: 1) The document it would act upon would be exactly the document you receive or you're transferring the data into some 'master' More

$75 USD in 2 days
(5 Reviews)

My proposal is to deliver as a windows app which will do the same thing as you mentioned. I have done similar jobs for other clients. Thanks, Sheik

$50 USD in 2 days
(5 Reviews)

Hello, I am a freelancer EXCEL EXPERT with Ms-Excel Related work Including Macros with 10 years of Exprience. I have already completed About 2000+ On Various Freelance Websites like freelancer, elance and guru. More

$83 USD in 1 day
(3 Reviews)

I have 10 years of experience with macro excel. I can do this job for you with a competitive price. After finishing, you will have 100% control of the VBA macro code.

$45 USD in 3 days
(1 Review)

I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power point etc.

$35 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)
$155 USD in 3 days
(0 Reviews)