Repeating Macros w/in the same spreadsheet

[S Larkin]

I use a couple of software packages that will only allow me to export reports to Excel. The reports are in Crystal format. As a result each group of data will only have one header. I need to put the header on each line of the data so that I can perform additional analyses.

I created a macro that would copy the header. However, the macro would only copy the header into the one specific group of cells that I used when I recorded the macro. (e.g. a13:a20) I was trying to get the macro to copy into all subsequent blank cells, using CTR End Down, then backing up one cell. (e.g. a13:a21 then change a21 to a20).

I need to have the macro copy each different header onto subsequent lines of data. Do you have a better solution or a way to make this work?

[dilipandey]

Hi S Larkin,

Welcome to the forum.

I believe Text To column feature can help here, could you post your one of your exported results here. Thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>