Replacing cell values

I have a macro that copies and pastes a job number and date from one page to another then goes through and deletes the duplicate numbers. Is there a way to expand it so that when a date is changed on the input page it will change it on the second page?

i'm not entriely sure what you mean but it sounds like you can either use a vlookup or a change event macro?

can you upload a sample workbook showing a before/after?

Please Login or Register  to view this content.

This is the code I have so far, I am also having a problem with some of the cells being dated when the job number is no longer on the input sheet

I meant uploading a workbook with how your data currently is in sheet1 and how you would like it in sheet2.

It will be then very simple to work out what it is you're asking as opposed to working out the above code.

Here is what I have going on. The highlighted yellow cells are the problem

Ahh i see. this should help you:

http://www.extendoffice.com/document...lue-above.html

That is not what I am after, It needs to be vba and an intersect code