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
Bookmarks