Results 1 to 7 of 7

Copy and paste cell range continuously

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2011
    Location
    Ryther, England
    MS-Off Ver
    Office 365
    Posts
    63

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1