Macro to Insert Column Heading to all Worksheet

[RAparente]

Hi.

Pls help me do a macro that upon clicking a button it will copy and paste a column heading (located in Row1 of Sheet1) to all non-empty worksheets (Sheet 2 to Sheet N) in the workbook simultaneously. Note that each worksheet has no column heading and has the same number of columns as that of the column header in Sheet1. Worksheet 2 to Worksheet N contains data extracted daily.

Im a newbie in macro programming.so i really needed your help ASAP. Thanks in advance.

[royUK]

When you say that you want it copying to non empty sheets is there data in Row 1 of these sheets?

[RAparente]

When you say that you want it copying to non empty sheets is there data in Row 1 of these sheets?

YES. the data starts in ROw 1 of each sheets.

[royUK]

So you need to insert a row before copying. This will add the contents of row 1 in the active sheet to each sheet after inserting a row

Please Login or Register  to view this content.

[MatrixMan]

Inserting a header only if the sheet is not empty ...

Please Login or Register  to view this content.

Hope that helps.

[RAparente]

So you need to insert a row before copying. This will add the contents of row 1 in the active sheet to each sheet after inserting a row

Please Login or Register  to view this content.

Hi.

It works!. Thanks a lot! More power and have a nice weekend!

[royUK]

Please mark the thread solved & rate the answer(s)

[RAparente]

thanks Again!