Merge rows by condition from one workbook to another

Pike, thank you, i will give this a try tomorrow and post my findings.

Could you inform me a bit further upon

some sensibility checks

What checks need to be done and how. What do you recommend (based upon your own experience) ?

Based upon the merging process of the rows, depending on the first cell (A1) is it possible to hide that cell (with the unique id) in the new generated file? This because the end-user does not need to know this id.

Thank you in advance!

This code returns an automatisation error.
Hereby my full code:

Please Login or Register  to view this content.

Hereby the files:
Kopie van Datarapport.xls
Datarapport-filter-UiTagenda.xls

The first file is the source file, the second the filter file containing the VBA.

Could you trace the inoccurrencies and help me further? Thx!

Pike, that does the job!

But how do i use this code together with above mentioned code (the copy of only specific ranges) ?

Pike, I still get an automisation error.
Maybe I need to include the A-column on which the merge-proccess applies?
Please advise.

I still get an automatisation error.

Here is my code:

Please Login or Register  to view this content.

And here is a screenshot of the error message:
ScreenShot002.jpg.

Thank you and regards,

Ok, thank you!
As you must have noticed, i don't have any VBA-code experience, just beginning to learn and most of all: trying to understand every step.

The code as it is right now (my latest post) seems to do the work so i'll hang on to that.

Just one question about following code snb helped me with:
to split the time in cell A1 to cell B1 and C1:

Please Login or Register  to view this content.

This code needs to apply to the G-column (G2:G). So time-data from this column needs to be exported to G and H-columns. How top adapt this code doing that?

Now my other concern is to offer the end user the ability to create a selection of rows (with checkboxes?) and then (by pushing a button?) export those rows to a new file. Can you assist on this as well or is it preferable i start a new thread?

Thx.

Thank you.

@snb: I will do that. Thank you for the advice.

In the meanwhile: can you or someone else help me with my questions in the post above:
- splitting time
- create checkboxes and let users export the file to a new one?

Thank you.

I used some vba and some formula's. Works nice. Thank you for all your help and i'll continue reading my book. In the meanwhile i hope i can count on your help on future issues. Thank you.