How to combine several tabs, delete first six rows and need to add one column with date

[mon123]

Hi, all

I need to merge the attendance record monthly. I.e. for Feb 2018, will get 28 worksheets in one file. I want to:

1. Keep the heading (first 6 rows), show one time is enough;
2. Add the column with date in the first column, around 100 records per tab (each tab is the date as tab name)

Please advise. Thanks

Mon

[JLGWhiz]

the date column parameters are a little vague, but try this, assuming the source workbook Is the active workbook and is open and code is not in that workbook. The workbook containing the code must be saved as a macro enabled workbook.

Please Login or Register  to view this content.

This code can be improved by giving the workbooks and sheets some actual names.

[mon123]

HI, JLGWhiz

Attached please find my data file for your reference. I copied and paste the VBA code under the worksheet but not work. Please assist. As I am the beginner of VBA, still need to time to understand. Thanks

For the merge page:

(1) Need the first six column header
(2) Combine A7 or below data
(3) Insert the column in the left hand side of A1 with date from A1 to column end (the date already shown in the tab name).

Hope it is clear. Thanks for your kind advice.

Mon

[JLGWhiz]

HI, JLGWhiz

Attached please find my data file for your reference. I copied and paste the VBA code under the worksheet but not work. Please assist. As I am the beginner of VBA, still need to time to understand. Thanks

For the merge page:

(1) Need the first six column header
(2) Combine A7 or below data
(3) Insert the column in the left hand side of A1 with date from A1 to column end (the date already shown in the tab name).

Hope it is clear. Thanks for your kind advice.

Mon

It will not open the attached file. But I tested the code before I posted it and it ran as expected. See my comment about using the actual workbook and sheet names. Also, make sure the code is copied to the standard code module1. If it produces an error, note the error message and the line of code highlighted when you click the 'Debug' button. Then post that information back here for analysis.