VBA to copy paste header from specific column

[Abhishekghorpade]

Hi

I want to Copy & Paste the following headers starting with the first date field (new column H) with macros.

DoB

DoH

Entry Date

Term Date

Disable Date

Death Date

Officer Staus Cd

Own%

YTD OverrideHrs

SrceLev Elig OptCd

Div

Term

Rehire

<tbody>
</tbody>

can anyone help me with that

 

[Joe4]

If you turn on your Macro Recorder and record yourself manually copying the cells you want to copy, that may give you the code that you need.
If it does not, please explain the details of exactly what you want to happen (be specific, in using column/sheet references, etc).

 

[Abhishekghorpade]

I just figured out the way to do it.. Thank you so much for your time