Macro Copy and Paste Function

[Hemingway254]

Hi all,

I am having trouble using Macro which is my first time using it.

Essentially to keep it simple on 'Sheet 1' I have personal data with grouped data so info can be hidden/ displayed on demand. I have a list of surnames and there personal details listed below but grouped so it remains hidden unless opened.

What I want to achieve is for on 'Sheet 1' I want next to each row a macro button which when clicked will copy and paste the group of cells hidden.

Then on 'Sheet 2' for the info to be pasted below a header title.

I want to do this because I want on 'Sheet 2' to have another macro button to export the data in a PDF document.


I want to do this because it will make it easy to export a range of cells on 'Sheet 2' into a PDF document.

So on 'Sheet 1' I will need a button at the end of a certain row which will copy and paste the info grouped beneath it onto 'Sheet 2'.

I have found codes to do the above however, I am having problems with coding to move the range of cells i want to copy/paste every 30 rows down.

The grouped data i want to copy/paste is every 30 rows down. Next to this row I would want a button that will copy and paste this data onto 'Sheet 2'

Hope it makes sense. Sounds more complicated than it may need to be. Thanks in advance