Copy and paste cell range continuously

Hi guys

I am looking for guidance on a copy and paste request.

In cell range A1:A5 I have the following details:
A
1. Property No.
2. Mtg Provider
3. Mtg Payment
4. Property value
5. Outstanding mtg

Then in cell range B1:B5 I want to be able to input the relevant info. Example:
A B
1. Property No. 1
2. Mtg Provider Barclays
3. Mtg Payment £300
4. Property value £70000
5. Outstanding mtg £35000

Once this is complete I then want to be able to copy and paste the data to cell range D1:E5.

Then I want to enter a new set of responses in range B1:B5 and copy the data again in range D6:E10 and so on.

I hope this makes sense. I have attached a sample to illustrate my request.

Your help and guidance would be much appreciated.

Cheers

Mac

Hi there

No. The data in range B1:B5 needs to be manually input. So range A1:A5 would remain constant and data in B1:B5 would be input by the user.

Regards

Mac

Hi again

Basically yes.

In sequence it would look like this:

User inputs into cell range B1:B5
Run macro to copy range A1:B5
User inputs into cell range B1:B5 again
Run macro to copy range A1:B5 again
Etc

It may be useful for the macro to clear range B1:B5 after the copy and paste as well.

Cheers

Mac

Hi there

That's fab thank you

Regards

Mac