How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Software Engineer
Category: Programming
Satisfied Customers: 1917
Experience:  Extensive Knowledge in PHP, MYSQL, CSS & Javascript
62934938
Type Your Programming Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I need to write a macro or formula /paste based on specific

Customer Question

I need to write a macro or formula for copy/paste based on specific criteria
Submitted: 1 year ago.
Category: Programming
Expert:  The-PC-Guy replied 1 year ago.

can you send an example of what you want to do?

Customer: replied 1 year ago.
it is an example. the the quantity of rows can be different
Expert:  The-PC-Guy replied 1 year ago.

what exactly are you trying to do?

Customer: replied 1 year ago.
Sorry, cannot help. There is another example of what I was doing manually. Please find the attached
Customer: replied 1 year ago.
cannot call, sorry
Customer: replied 1 year ago.
Format file for payroll calculations
Insert 1 new columns before column A
Copy the Provider names into column B for all the rows that have CPT Codes for that Provider
Expert:  The-PC-Guy replied 1 year ago.

if from the looks of it, it looks like you are trying to copy the first value in column C for each set of data and copy it to each of the rows in column A?

Is that what you are trying to accomplish?

Customer: replied 1 year ago.
you are correct, we have hundreds of pages of it. Is there any way to do it more efficiently?
Customer: replied 1 year ago.
Copy the name of provider in column A and drop it down
Expert:  The-PC-Guy replied 1 year ago.

Not that I can think of, its not an impossible macro to create but is a bit complicated. For that reason I would have to charge a bit more. I am sending an offer for additional service.

Expert:  The-PC-Guy replied 1 year ago.

if you accept it I can create the macro

Customer: replied 1 year ago.
Sorry, but it is possible. There was a simple macro I have copied and corrected a little bit and it worked, but erroneously deleted. if you cannot help just reverse charges
Customer: replied 1 year ago.
no, thanks looks like a fraud. 20$ for phone call 37$ more for simple macro...
Expert:  The-PC-Guy replied 1 year ago.

what phone call?

I don't remember mentioning anything about a phone call.

But hey good luck to you.

Since my time is not valuable to you, I will opt out of this question and open it to others. Maybe you can find someone who will do it for very little.

Customer: replied 1 year ago.
$57 is not very little
Expert:  The-PC-Guy replied 1 year ago.

i will do it for you for the price offered. But I will only do it once, so the best bet, if you could send me a file without the value already copied that is in the same format that your main file is going to be on, That way I could make sure that it works with the format of your actual worksheet in order to prevent any compatibility issues.

Related Programming Questions