Need someone to edit some of my code. VBA

$10-30 CAD

Completed

Posted

over 6 years ago

$10-30 CAD

Paid on delivery

My project will not take long. Probably under 30 minutes only. I wrote some code with VBA and it needs to be adjusted to fit my intent. I am trying to copy the data between Row "D" and Row "P" from the Worksheet(Take-off) to the Worksheet(Glass Schedule). Though the only data I want to copy would be that of which contains text in column "D". If there is nothing in column "D", I do not want to copy the text between Columns "E" and "P". I hope that makes sense. I highlighted all of the data that would be transferred in yellow for your convenience. I attached the original excel document as well as a screenshot of the code I already have. There are some things about the code I already have that I know are wrong and require editing. Firstly: The Value in the code should not be limited to only "GLASS" but anything, so long as it is not empty. Secondly: I need it to only copy the data between rows D and P out of Worksheet(Take-off) as previously mentioned. Not unto the last row. Thirdly: I also need the total in the Worksheet(Glass Schedule) to equal the multiplication of Column "O" and Column "Q" in Worksheet (Take-off). Thanks for your help!

Excel Macros

Excel VBA

Project ID: 16054269

About the project

9 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i can help you modify your macro in matter of minutes. This is pretty simple task, so if you are interested i will help you immediately.

$15 CAD in 0 day

5.0

(23 reviews)

4.8

9 freelancers are bidding on average $36 CAD for this job

@P0L

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

$50 CAD in 1 day

5.0

(10 reviews)

5.0

@aubrey03

I am an Excel VBA expert. I can edit this code so it would work as per your requirements. Feel free to contact me so we can discuss the details of this project.

$30 CAD in 1 day

4.6

(34 reviews)

5.1

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$30 CAD in 0 day

5.0

(4 reviews)

3.4

@dkozh

Hello. Every day I encounter such problems. I will do everything as quickly as possible. The price is reduced because you must earn a rating. I will be glad to cooperate with you.

$14 CAD in 10 days

5.0

(4 reviews)

2.7

@musthree

Dear friend, let me do it in 10 mins. But why are you clearing contents of Glass Schedule on workbook open. There is no problem if you aware of what you are doing but I will suggest no to do such things. Instead assigning the execution to a key is better but again it depends on you.

$20 CAD in 0 day

5.0

(1 review)

1.1

@ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget.

$25 CAD in 1 day

5.0

(1 review)

0.4

@sjDavidson

Hi, I've been working with MS Excel for twenty years building proven spreadsheets for clients. I can also work with VBA, macros and forms should they be needed in your project. I also write a document of instructions to help you use your spreadsheet for the long term and so other people can understand if you need to alter it in the future I'm sure I can help you get the solution you need Stephen

$30 CAD in 13 days