Macro to search based on creteria cut and paste

hi,

This is not a solution but is guidance on how to solve your own problem...
(People may be more willing to help when they see you've made a start.)

The best way to start solving this is to record a macro of your actions & then look at & modify the resulting code.

To record a macro press [alt + t + m + r], enter a name with no spaces (eg CopyAndPasteMacro), press [okay], complete the actions you've outlined, and stop the macro recorder by pressing [alt + t + m + r] again (or pressing the Stop button on the small toolbar which may have popped up when you started recording).

Press [alt + F8] in Excel, select the macro you've created and press [Edit], & this will show the recorded code in the VB Editor.

With this base code, the job's half done & you can ask questions about any specific problems (eg what happens if the cheque # is not found/how to change the cheque # etc).


Rob

hi Kish,

Hopefully you've been able to work out a solution but just in case you haven't I thought you may appreciate some help (instead of my bluntness yesterday, sorry about that) - please see below for a macro which should do what you've asked. Test it on a copy of your data & if something doesn't look right let me know & I'll see if I can fix it for you...

Please Login or Register  to view this content.

This macro has some error checking in it but it doesn't check for the same cheque number appearing on 2 lines or to see if anything is already in column D - hopefully that wouldn't happen...

hth
Rob