Hi,

When I record macros the column header letter is always referenced. I'm trying to do the following:

Situation:

I have a column header in row A of worksheet1 named "color" and a column header in row A of worksheet2 named "color".

Goal:

Search for the name of the column header ("color") in row 1 of worksheet1 and then copy all of the rows of data within column "color" to the first available blank cell within the "color" column within worksheet2.

Any assistance is appreciated..