I need help creating a macro. I dont not know to write codes, I just record
a macro, doing the steps. See eg. below.
I have been able to copy the vendor name next to the invoice numbers, and
need to go to the next vendor ID "CALADIUM" and repeat the same process.
Also need to continue to end of data .

If codes are given, I would need detail instructions please. THanks

Cristina Seawell

A B C
D
Vendor ID
Brodies
Invoice #1 6/3/2010 $10.00
Invoice #2 6/4/2010 $20.00
Invoice #3 6/5/2010 $30.00
Invoice #4 6/6/2010 $40.00

Vendor ID
Caladium
Invoice #5 6/3/2010 $10.00
Invoice #6 6/4/2010 $20.00
Invoice #7 6/5/2010 $30.00
Invoice #8 6/6/2010 $40.00

I made a macro and have been able to copy the vendor ID next to the invoice
Numbers for Brodie, then a search for "vendor ID", and selected the cell
above CALADIUM. then would like to move to next cell below and copy the name
Caladium next to the invoice number(will copy the codes already in the macro)
and continue down the sheet until there is no more data.