Compare

Hi,

Please review our https://www.excelforum.com/forum-rul...rum-rules.html
Start with the first one ! (then edit your post above and Select Advanced to change the title).

Then if you plan to attach something (ant it's often wise to do so), follow the suggestion below:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

You were geting this error from error handler part of the code. The main reason was because somebody (you?) pasted the code not in standard module, but in code of thisworkbook object.

I moved it.

Moving it to proper place cure just this one problem, because code stops now at searching sheet names 07, 08 in first rows of these sheets. But to deal with it understanding idea behind a code (the task and the approach) is needed.

And I kindly remind you about:

https://www.excelforum.com/forum-rul...rum-rules.html
Start with the first one ! (then edit your post above and Select Advanced to change the title).

You probably shall ask for it somebody from forum administration, because 2 days passed since thread was published.

Use link "Report post" below your post. Do not expect my activity in this thread before title is corrected.