Merge/Consolidate Multiple Timesheet data into a Single Sheet

Guys,

I hope that some one can help with my current Excel dilemma. I have tried to get to grips with the programming concept of VBA with a limited amount of success and as highlighted in my previous post http://www.excelforum.com/excel-prog...html?p=2920209 think that i'm about 80% of the way there.

What i'm trying to achieve is to consolidate 6 sheets that are time sheet templates into a single sheet every month, now i've managed to consolidate the data into a single sheet, however, i only want the macro to copy a row if a date is entered into the first column and not to copy the 851 rows part completed as a template.

I have attached a copy of the spreadsheet and would appreciate any help to complete this.

Thanks in anticipation.

Arlu,
Your code only copies the heading, not the rest of the data. I like your simple code of consolidating sheets and keen to include on the code how to copy the names of each sheet in the master sheet in column "A". For e.g in the attached Macro by Ron, the name of each sheet is copied in the column H. How do you incorporate your code, so that it does the same as Ron's but the name of sheets should be in column "A", not "H"?

Arlu,
I was not the one who asked the question, but have commented on it. I have now incorporated your code in to my spreadsheet and correctly pasted the names of each sheet in each row, so I have got the solution I have been looking for and now know how to include names on column A.

Thanks for your help and will pass the button on to digbat

Arlu!
I have seen most of your codes on consolidation and like them for thier simplcity. Instead of posting another question for just one i,e getting the names of sheet in the master sheet, It would be easy for you just to include it with this thread. I was not posting a different question on another thread. If you look at my request, it just says to include on the code, not to ask a different question. Sorry! If you took it wrongly.

Arlu,

Many thanks for your help, was going to ask you about the sheet names appearing in each row but you beat me to it, going to tweak it slightly to sort data by operator and then date, but should be able to manage those changes.

Thanks again.

Dingbat

Arlu,

Just when i thought it was sorted... I have come across an issue now as i've protected all the worksheets to prevent user access and the macro won't run. Just need to protect all sheets/workbook with same password and assume unprotect whilst macro is running? I hope this is an easy fix.

Thanks in anticipation.

Dingbat.

Arlu,

As pointers on the code i should used as i did the usual googling and entered various suggestions which did not work, ideally would like to run macro which automatically unprotects and then protects for me.

Thanks

Dingbat.

Arlu,

Thanks again, you've been a great help in solving my VBA issue, and i've learnt a lot about VBA in the process.

Dingbat.