How to have macro copy & paste cells below collapsed group?

You can try this calculation of true last row:

Please Login or Register  to view this content.

instead of this line:

Please Login or Register  to view this content.

Okay so it only works once, because it keeps replacing the same cells every time I run it. I leave 1 blank row at the end of every checklist to separate the projects, and this macro is now adding another blank line before pasting the cells, so the macro sees that space and thinks that's where it all ends.

May be it would be better to set the Header for every project... then macro would see this header instead of space. Is it possible?
Like here:

Attachment 666208

Also you can calculate true last row other way (but I don't like this way):

Please Login or Register  to view this content.

I have attached a copy of the file (minus details) so you can see what is happening. The macro is linked to a button on the toolbar (far right tab).

I cant' see the example you posted about, I don't have admin privileges apparently.. lol But the reason I wanted to do it this way, was because its a pain to have to copy and paste in templates every time, besides that, I would like other people to be able to use this when it's finished, and we both know how terrible some people are with computers. I want it to be completely fool-proof - Push a button, template pops up, enter the information for this project and off you go.

As for your second reply; Will this fix my current issue? Why don't you like that method?

Also I forgot to ask, but which part of the macro code would I replace this new code with for it to function properly?

Hey there, sorry to keep bothering you , but have you had a chance to look at this again? I've been really struggling to find a solution to this

Sorry it took so long... I corrected my code and made it more universal. I tested it in your file and now it works. So just replace your code in Module1 on this:

Please Login or Register  to view this content.

As for your second reply; Will this fix my current issue?

About it... Yes, I thought it should fix your issue, but I didn't know that you have got merged cells in your data, so now I needed to change my code.

Why don't you like that method?

This method isn't universal and it isn't very "gracefully".

Re: "I didn't know that you have got merged cells in your data"
Merged cells should be replaced by "Center Across Selection"
I've seen helpers say that they refuse to help where there are Merged Cells involved.

Yes!! It works!!! So whats the defining difference here? I see a lot of new code, but what exactly is it doing? Thanks again!

I really want to thank you for helping me with this. This was the final step in completing my spreadsheet that I have been working on for months. It will now be used for my entire team!

My pleasure!
I'm really glad I could help!

So whats the defining difference here?

I changed the method of calculation of last row in destination worksheet. I wrote function named CalcLastRowNumber that returns number of the last row. This function checks every row in destination worksheet: if this row "is empty" (all values of cells in columns №№ 1, 2, 3 and 4 = "") and next two rows "are empty" too then we can think that the previous row is last.
Function RowIsEmpty checks if this row "is empty". Because there are merged cells in your data we should get value using MergeArea property. If we try to get data the usual way we can fail. That is because data contains only in first of the merged cells. Properties MergeArea.Row and MergeArea.Column returns the Row and Column of the cell which contains our data. So thats why we use MergeArea property.
So I hope you will understand my explanation. >.<

I understand well enough I'm really glad this project is now complete. Have a great day!