Find and replace

E

Eric

Hello all,
I am trying to make a macro to replace a row worth of entries based on a
date and job number.

A=Date
B= Job Number
IE:

A B C D E
1 5/15 1134 yes 650 $1,200

Replace the above with
600 5/15 1134 yes 750 $1,500

In this example I would hope that Row 600 will replace row 1 because A1 and
B1 match A600 and B600. I hope this makes sense and I'm sure its and easy
fix. I'm just not getting it. any help would be greatly appreciated. Thank
you in advance.

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top