I am working in Excel 2000.
I have a spreadsheet that contains duplicate cells of information within the
same column, but needs information within the row. I need some help writing
a formula or macro that would allow me to perform the following on the
worksheet:

If Cell A2=A3, then copy values in cells C2, D2, E2, and H2 to cells C3, D3,
E3.

Thank you for your time and expertise!